Problem inserting new worksheet in Excel daily time tracker w/ date format (at specific location in book)

[sschwant]

Hey Doc,

I think you've done it! Couple of observations: 1) If the Template tab is not hidden, then the macro copies that tab - so will just have to make sure it stays hidden. 2) The pivot table on the newly created tab ends up pointing to a different tab and it should always only be pointing to the data validation table on the currently created new tab for each iteration . . . I think I can fix this ... I will tinker w/ it and circle back later today.

Thanks!!
Steve
p.s., your handle looks awfully close to Albert Einstein ... coincidence?