Use links to the workbooks. 1 time setup.

='C:\My Data\[Myfile1.xls]Sheet1'!A1

Regards,
Tom Ogilvy

"Doria/Warris" wrote in message
...
Hi,

I have 10 workbooks which include 10 worksheets each (sheet 1 to 10, that
is, 100 worksheets)
They all have same format and formulas.

I need to consolidate them in one workbook which of course will also
include
10 sheets.
What's the best option I have considering that I want the consolidation to
be automatically updated once any of the 10 workbooks is changed?

Thank you
Alex