I would like to have suggestions on what's the best best way for resolving my
problem:

I have to turn in a report every week that consists of one summary sheet and
25 other sheets. The Summary sheet reads data from the Totals field in the 25
sheets and displays it. The 25 sheets are sent to me by the different
departments. I want a program so that I can save all the 25 sheets /
workbooks in one folder when I receive them from the departments and then run
the program that copies all the 25 sheets and the summary sheet template to a
new workbook and then do the linking between the summary sheet and the 25
sheets. Is there a way to do it without having to open all the 25 sheets and
then running the macro.

Thanks in advance.