Re-post of my reply to your same post of yesterday.

See Ron de Bruin's site to copy data from multiple worksheets within a
single workbook to a single sheet.

http://www.rondebruin.nl/copy2.htm

See also his add-in for moving data from multiple workbooks in case you ever
needed that function.

http://www.rondebruin.nl/merge.htm

Are you not seeing replies?


Gord Dibben MS Excel MVP

On Wed, 18 Nov 2009 09:10:02 -0800, Supe
wrote:

I have a file that has 60 different tabs that shows the vendors UPC, Dollars,
and units for their items. Is there a way to move all of those into one
worksheet?