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