Consolidate Text from Various Sheets in Same Workbook

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

No, it doesn't need to be there.
Thank you.

Thanks for that. I forgot to mention, the position of the column is different in each sheet. There are about 5 sheets I need to copy from, in one the id ref is in col B, in another it's in B etc.
Will the code still work?

Also, is there a non VBA way to do it? I would prefer if it wasn't VBA :$ (sorry)
The summary sheet has other bits of data in it that I can't amend at the moment, I need the list of copied data from A3 downwards.

Arlette- no it is not. There are other columns of data in the summary sheet that I'm not supposed to amend!!

There are also other columns in each of the sheets that I need to copy the data from. All contain different pieces of information in different formats!
(just to make it interesting!!)

Post an example workbook so that we can see what variations you have.

Pete