Not sure if this helps but here is a consolidation routine...

http://www.rondebruin.nl/summary.htm
--
HTH...

Jim Thomlinson


"AccessHelp" wrote:

Hi,

I have an Excel file containing 10 worksheets. One (Sheet 10) of the 10
worksheets is used to pull the data from other 9 worksheets that users key
in. At the end, Sheet 10 will have about 1000 records from the other 9
sheets.

Instead of linking the cells to Sheet 10 from other 9 sheets, what would be
the best way to pull the data from other 9 sheets? Would the "Name" feature
work? How about "Label"? Any other recommendation besides "Name" and
"Label"?

Thanks.