Automatic Sheet Generation Macro

Hi guys.. I really need help with making this..

I am attaching a mock sheet...

I need to automatically generate sheets inside an excel file ..

The Ingredient Recipes is the first sheet.. on this sheet the first row (in yellow) is from where the names for each new sheet should come.. Lemon Mustard, Falafel, Iceberg Lettuce.. Etc. Then step two in the macro would be to copy the contents (with all the formulas) of the sheet named Template into each of these new sheets that were generated .

In the mock file I added the lemon mustard sheet.. That's what a new sheet would look like once the macro has worked.

To create the template sheet:
(my template is named "template_ev", and "newpath" is a variable I set to be "activeworkbook.path")

Please Login or Register  to view this content.

Then, make your list of variables into a named range.

Then, use

Please Login or Register  to view this content.

can you by any chance put the code into the excel sheet attached.. unfortunately i am not sure how to adjust it to make it work..

Please Login or Register  to view this content.

wow.. thats amazing!! thank you so much!!!!