Ok here's a little detail.

I one sheet(tab) I want all items merged from 11 other sheets(tabs).
need all items on the 11 other sheets. The number of rows will be varie
a specfic number of rows is unknown for each sheet. I do however kno
that there are a specific number of columns that is 16, this is tru
for each sheet. This is all within the same workbook. it needs to be
refreshed type senerio each time ran not a continunce of the previou
run.

So each row of data on each of the 11 sheets needs to be brought ove
to one common sheet with an unknown number of rows in the 11 sheets.
Anyone help me out here?

Thanks IN+Vance
Michae

--
Michael Wis
-----------------------------------------------------------------------
Michael Wise's Profile: http://www.excelforum.com/member.php...nfo&userid=699
View this thread: http://www.excelforum.com/showthread.php?threadid=26561