i am quite new to excel and I would like to know a macro or vba to automate the task i am trying to prepare.

first off, the data to be copied is on different spread sheet. the data is located on the same column of each sheet.

what I want to do is, to consolidate all of the data on a new worksheet and put them in one column.

basically want i want to do is to copy the data on each sheet and paste in in a new sheet and do the same on the next sheet and paste it again right below the first data i copied.

sorry for the long post, hope my explanation is clear enough. THank you.