Welcome to VBAX MasterBash. A quick correction if you don't mind. Templates cannot be saved as a template sheet. I refer to the following from Microsoft

A template is a pre-defined workbook (with one or more worksheets) that can be used to help you create your final workbook. Using templates that contain pre-formatted worksheets can save you a lot of time. Every time you select (File > New) a template is used to create the blank workbook.
Don't save data to a template. Open the template and save it as a new workbook with a xlsm format. With the new workbook, you can implement the following code

Sub NewNamedSheet1()
     Dim ws As Worksheet
     Dim NameCount As Long
     Dim NameBase As String
     NameBase = Format(Date, "mm.dd.yyyy")
     Sheets.Add(After:=Sheets(Sheets.Count)).Name = NameBase
End Sub