Create a master workbook. Then in VBA activate each workbook and copy each
sheet into the master workbook with a Sheets.Copy command. The save the
master.

Try it with a small sample using the Macro Recorder to get the correct syntax.
--
Gary''s Student


"caldog" wrote:

I want my end users to not lose the master worksbooks, that they have. So
how do I have them save say five worksbooks as one file name, thereby not
touching the original workbook.

Now I'm a novice at coding in VBA, so please explain so that a novice can
understand.

Example say I have these workbooks:
Room & Board.xls
SOC.xls
Refunds.xls
TimeSheet.xls

What I want to see is the above four workbooks save as say September 2005.xls

Thanks

Steve