Hello

I wish to design a VBA that allows me to alter the number of sheets in a template excel file
The template excel file contains a set of blank sheets, and a final summary sheet at the end, hence I wish the VBA to adjust the number before the summary sheet

If possible, I would also like the VBA to rename all the blank to the specific dates ie ddmmyyyy

Ideally, the VBA is designed within excel, and I could enter the number of blank sheet I want, and the range of the dates, and the VBA detects it and adjust my template sheet automatically

Many thanks

Thsi is what I have so far, I'm a programming noob

Sub newsheet()
Dim newsheet As Worksheet

Set wks = Worksheets.Add(after:=Worksheets(Worksheets.Count - 1))
wks.Name = "Sheet" & Worksheets.Count + 1
With wks
.Cells(1, 1) = "TTL Corp."
.Cells.Font.Bold = True
.Cells(1, 6) = Date
End With
End Sub