Excel Copy Worksheet Rename. SImilar to norie's approach (that I jsut saw when getting ready to post this) is simply copying your master/template sheet (it looks like you are copying everything). How to create a new worksheet in Microsoft Excel, rename a worksheet, delete a worksheet, copy a worksheet, and even move the worksheet sheet tab.
How to Easily Copy Excel Worksheets To Avoid Tedious Copy ... (Lola Olson)
You need to copy and paste the code into the VB Editor module code window. Just changing the name is quite simple. This set of keystrokes activates the ribbon commands.
Renaming any excel worksheet is as easy as renaming any file.
Actually, this solution is not harder compared with the solution above. Copy worksheet within Excel workbook is very easy. Open a new excel sheet and type any data.