Hi
yes, check out Consolidation on the Data menu or Pivot Tables -
consolidating multiple ranges.
Cheers
JulieD
>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?