I have added a "Workbook Open" macro which checks today's date (NOW() function) against the date is row 1 of summary and finds the first date which is less than today's date. It then checks if the corresponding "generated" tab name in row 2 exists: if not, it copies the "Master" tab and re-names it to the appropriate tab names. If the tab exists, it puts out a message (highlighted in red) which can easily be moved if necessary.
The attached has "JAN9_JAN14" added. If you test on Monday it should add the next .week (JAN16-JAN21)
Bookmarks