how do i insert new sheets in a workbook with my template on each sheet

a) The template file must be in the correct location. Open the Windows Explorer and copy this path into the address bar and press ENTER:

%appdata%\Microsoft\Templates

Do not create a Sheet template, because that will be used every time when you insert a sheet in any file!

b) How to use it:

Right-click on the sheet tab and choose Insert...

Select your template and click Ok

Note:

Your template file can have one or more sheets, doesn't matter. If your file already contains a sheet with the same name as in the template, the new sheet will be renamed automatically.

Andreas.

Hello 2tiredlazy,

Welcome to Microsoft Community.

I am a Microsoft user just like you, I hope you are doing well?

You will need to add a default worksheet template for this. Kindly find steps below for guidance:

1. To use a worksheet template, create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information that you want to appear on all new worksheets that will be based on the worksheet template.
2. Click File > Save As.
3. In the Save as type box, click Template.
4. In the Save in box, select the folder where you want to store the template.

To create a custom worksheet template, make sure that the Templates folder is selected.

The path is typically: C:\Users<user name>\AppData\Roaming\Microsoft\Templates

5. In the File name box, to create the default worksheet template, type Sheet.
6. Click Save.
7. Click File > Close.

Source: https://support.microsoft.com/office/6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19

Please let me know if you need more assistance.

Give back to the Community, Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Warm Regards