Hi All

I need to aggregate data from 100 different workbooks into one summary worksheet. The spreadsheets are all idientical.

What is the quickest way to do this? Can I avoind very long, ugly formulas?

Thanks in advance.

I need to aggregate data from 100 different workbooks into one summary worksheet. The spreadsheets are all idientical.

What is the quickest way to do this? Can I avoind very long, ugly formulas?

Thanks in advance.

## Comment