Save Excel File by Month Created (VBA or non VBA).. :)

[Partypiepom25]

Hi,

I hope somebody can helo

I have a standard report which is being reused by managers.

What I want them to do is to overwrite the report each month, but not use the previous months data. So after a while there is a report.june , report.july etc

Then I can move all workbooks automatically into one workbook where the reporting sheet sits.

Thanks in advance

John