Move data from mulitple tabs to one sheet

[Supe]

I have about 60 tabs that have the item UPC, dollars, and units for 60
different vendors. Is there a way to move the data from these tabs onto one
sheet without copying and pasting from each tab?

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Herbert Seidenberg]

Excel 2007
Consolidate Tables on multiple tabs
to generate PivotTable.
Generic data in no particular order.
http://www.mediafire.com/file/jmj2ogyrzet/11_17_09.xlsm