It feels like a short forever since I've sat infront of Excel and to make things worse I've not got any of my legacy files to poach from, so I feel like I'm starting all over again.

So far, with a bit of google/help querying, I've got my worksheet and file references and smart objects back into my headers, footers and such - but for the life of me I can't recall how to have a column automatically-fill-down-list-reference another, on another worksheet, that expands to accommodate new line entries as and when they occur.

So far I've simply got the most basic of ='worksheet'!A1 - then dragged that reference down as many lines as needed - but that's a horrible way of doing it, and I definitely have done this before, where basically the data in one worksheet "just" referenced into the cells of another, automatically populating with the data, and growing down as it grew/changed.

The only difference being that the "output" worksheet is all nicely formatted (where the original data worksheet is left "raw").

Am I making any sense? My search efforts keep returning the "wrong" things.

Only just spotted your post so very sorry about talking so long to reply.

The only thoughts i have would be using either the consolidate functionality or the advanced filter functionality both take information from one sheet and manipulate it ad put it into another.

Sorry probably not very helpful.