Hello,
I have a macro that creates a new sheet from a template and renames these tabs based on a list. The template is called "Template" and the list is in column A of a tab named "List". See code below.
Sub Copy_Sheets()
Dim i As Integer
Dim wks As Worksheet
Dim Last_Row As Long
Set wks =...