Automated Exporting Sheets?

Hi,

I have a query regarding finding some code/macro even to automatically export and arhcive records from a sheet in my workbook on a monthly basis. I would therefore like all the data on one sheet to;

- be copied into a new workbook at start or end of every month
- workbook named correctly by month
- data from original sheet deleted

This is the process i am trying to automate. I assume it would be built into the module of the workbook....Can anyone give any help on code to use.

See my current work attached if need be -

Many Thanks

Does anyone have any knowledge for me on this????

Any help at all would be greatly appreciated...

Thankyou!