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