Alan,

Thanks - your code is working, but isn't exactly what I was trying to do ... My file is meant to be a daily time tracker. There are 4 tabs to start:
1) "Task List" - this is static and for reference only,
2) "Activities & Macro" - also static w/ a button to launch the macro,
3) "Template" - also static, but meant to be copied as a new date formatted daily tracker/time keeper. It has a table w/ 3 columns B: time by by 15 minute increments, C: data validation drop down list referring to the list of activities on the tab # 2, and D: hours = 0.25 per row.
4) "08-09-20" - first date formatted tab. To start this can be blank (I think). Ultimately though it would be a copy of the Template tab but w/ a simple Pivot Table appended to it - which summarizes the activities by a sum of hours and count of activities - which is included in the code already.

The goal is to have the template copied as a new date formatted tab w/ the pivot table, inserted to the right of the Activities & Macro tab. Then as the cycle iterates - all previous dates are pushed off to the right. Initially, all new sheets were inserted at the far right of the workbook, but as the process iterates, it gets cumbersome to keep scrolling way left to get back to the macro button on the Activities & Macro tab.

So, is there are a way to edit your macro such that it copies the template?

Thanks!
Steve