Linking multiple files

[Therese]

I want to link multiple Excel files together and create a summary in a
separate worksheet. All of the files are formatted exactly alike. I don't
want to combine them into one worksheet because each sheet is needed on its
own. Any suggestions?

 

[JulieD]

Hi

yes, check out Consolidation on the Data menu or Pivot Tables -
consolidating multiple ranges.

Cheers
JulieD