Create New Excel Sheet plus copy data from different sheet

Hi,

I have an excel workbook with one sheet as a template and below VBA macro to create a new sheet. Id like to add to this macro that whenever new sheet is created he also paste whatever is in "template" sheet into newly created sheet. Both template sheet and new sheet are in the same workbook.



Option Explicit

Sub AddSheets_TodayTest()

Dim szToday As String

szToday = Format(Date, "dd.mm.yyyy")

On Error GoTo MakeSheet

Sheets(szToday).Activate

Exit Sub


MakeSheet:
Sheets.Add , Worksheets(Worksheets.Count)
ActiveSheet.Name = szToday

End Sub