**Resolved**Combining Multiple Excel Sheets

[gtg689a]

Ok here is the issue:

I have a macro that runs a report. It changes one cell in the report(which updates it to a new cost center) and then saves a hardcoded copy to a folder and leaves the workbook open. It does this for about thirty reports.

Now what I want is to do this....
I have folders for thirty people named "John Doe", "Sally Mae", etc.

After the macro has run the reports, and they are all open I want it to stick the appropriate file (which have names like 2431, 2541, 2786) in to the correct folder. Sometimes the file needs to go in to multiple people's folders.

Now here is the kicker, sometimes a manager wants multiple reports and wants them all combined into one workbook.

Any ideas?

-Thanks!!!!!!!