Duplicate Excel Worksheet from names column

Ok, first ensure that you have a macro enabled workbook open.

1. Click on the Developer tab
2. Click on Visual Basic
3. Click Insert and then Module
4. Copy and Paste this code into the VB code window

Sub DuplicateNameSheet()
'
' DuplicateNameSheet Macro
'
'

   Dim i As Long, LastRow As Long, ws As Worksheet
   Sheets("names").Activate
   LastRow = Cells(Rows.Count, 1).End(xlUp).Row
   For i = 1 To LastRow
        Sheets("template").Copy After:=Sheets(i)
        ActiveSheet.Name = Sheets("names").Cells(i, 1)
    Next i
    
End Sub

*Note with the above your template sheet needs to be named template and your the sheet with your names on it has to be named names