copy master sheet and rename sheet with date format

I have a calendar on the book which selects the corrospending sheet when a date button is pressed.

Is there a way for a similar system to generate/insert a clone of a blank template sheet and name it acording to which date/month/year button is pressed?
At the moment i just copy the sheet one at a time and rename each sheet (the name has to be exact for the selection calendar to find them)

Once again thank you for your help

Peter

This is exactly what I am looking for - have you found a solution?

Hi
I have attached finished project
If you put you template sheet in place of mine it should work
if the open the calender from the button on the sheet it will select a sheet if the date name is there it will ask if you want to add one if its not, it will place a new named sheet behind the active sheet


enjoy

Peter