Automatically generating duplicate workbooks renamed with incremental dates

[K80flo]

Hi, I'm used to basic Excel usuage but I'm trying to do nothing which I know is possible but I just can't work out how to do it.
Please can someone help.....

I have a Master Copy Template Workbook with a date in A1 I want to automatically generate identical sequential editable workbooks BUT with a new date for each..
i.e. 1st Workbook NAMED 01.04.2018 with the date also in A1 the next NAMED 02.04.2018 with the date in A1. etc:

Please help
Thanks

[AliGW]

Welcome to the forum!

It sounds as though you are about to fall into the same poor data layout trap that many others have fallen into in the past and regretted! Please explain why you need a worksheet per date: there is probably a better way.

[K80flo]

More than likely!
All the cells in the workbook relate to data input for activity for that day. A workbook needs to be kept for each day for audit purposes. The workbook has been designed to be simple to use as multiple non IT savvy people will access to input their data into specific cells & save.
There needs to be a new workbook generated for each day as it is a log of activity for that day.
Is that any clearer??