VBA - create new sheets based on names in a list/ copy format from diff sheet to new sheet

Hello All,

I'm working on a macro that will create new sheets based on employee names in a sheet titled "SUMMARY REPORT" as well as copy the format of my sheet called 'Template" and add it to every new sheet i make.

So far i have this code that successfully makes all the new sheets and renames them with the employee name but i cant figure out how to also copy the format.

Please Login or Register  to view this content.

The specific template i am trying to copy goes from A1:R3 in my "Template" sheet. If anyone has any pointers or thinks they know how to do this I would greatly appreciate the help!

Thank you! Do you know how I would be able to add the employee name/sheet name into cell A2?