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?