Hi,

I would like to combine lists of data from multiple worksheets into one master summary sheet.
It's one column of data from each sheet (col. heading = "id reference"). There may be multiple instances where the same id reference is in 2 or more sheets, but I want each instance to be copied, not just the one.
The ID references are sometimes alphanumeric and sometimes numeric only - I just want a list of everything in my summary sheet.

This is to be done on a weekly basis and the amount of data varies each week.
I've tried using the Consolidate function but it doesn't seem to work as I'm asked to select a function (eg. Sum) but I simply want to display the data in one long list!

EG:
Sheet 1:
abc123
wer123
ert2342
4567323

Sheet 2:
abc123
rtyhe35
w5235
k63g
rjhet5

Master Summary should then show all the above in on col:
abc123
wer123
ert2342
4567323
abc123
rtyhe35
w5235
k63g
rjhet5

Is this even possible, and if so, please help!!

Thanks,
L