Look in the Data menu as the consolidation function.

--
Regards,
Tom Ogilvy

"James Weaver" wrote in message
...
Is there a way to copy and paste data from one file to
another WITHOUT opening the source data file?

In addition, is it possible to do this from multiple files.

I am trying to design a financial consolidation tool to
add up the same worksheet from multiple versions of the
same file.