Urgent help: Creating new sheets with template included

[Vaughan.jamie]

Hi all

i am trying to create new sheets from a list but i also want to insert a template into these new sheets

i have created the template on another sheet and i am trying to copy and paste it to the new sheets whilst they are being created

this is my code so far

Sub Auto_Quotes()
    Dim MyCell As Range, MyRange As Range
    
    Set MyRange = Sheets("Summary").Range("A2")
    Set MyRange = Range(MyRange, MyRange.End(xlDown))

    For Each MyCell In MyRange
        Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
        Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
        Worksheets("Template").Rows().Copy 
        Worksheets("Template").Select           'copies template
        Worksheets("Sheets.count").Rows().Select
        Worksheets("Sheets.count").Paste
    Next MyCell
End Sub

It gets to the point where it copys the template to the clipboard but then fails and will not paste it into the newly created sheet

then after i have created this macro i will be wanting some help with another code that transfers the data over from the summary to the relevant places on the template

hope this all makes some sense to you all

i am still learning but honestly enjoying it as once you succeed it feels great
please find example at the bottom

cheers