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.


--
dromayn
------------------------------------------------------------------------
dromayn's Profile: http://www.excelforum.com/member.php...o&userid=29410
View this thread: http://www.excelforum.com/showthread...hreadid=491264