Quote Originally Posted by Paul_Hossler View Post
Maybe

When you say 'template' or 'template sheet' are you talking about an XLTX file (an Excel template workbook that is the basis for a new workbook) or a XLSX file (regular ol' Excel workbook) with a single sheet with formatting, prefilled data, etc. that you want to use as the basis for (say) a new worksheet in the current workbook named 'Sales Figures - 20240601" with headers, logos, formatting, etc.?
XLTX.

However, Aussiebear's solution is working great. I just need to make sure it doesn't throw any error if a user tries to run the macro twice for some reasons. I prefer his solution, because I can just make the macro run when the workbook is opened. It saves us some time.