Move data from mulitple tabs to one sheet
 

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?

Move data from mulitple tabs to one sheet
 

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

On Tue, 17 Nov 2009 13:12:01 -0800, Supe
wrote:

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?

Move data from mulitple tabs to one sheet
 

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