When you select New from the File menu, the New dialog box is displayed. Usually, the New dialog will have some tabs that organize the templates that are available. This example has the General, Spreadsheet Solutions, and Office 97 Templates tabs.
You can add your own tabs to this dialog by adding subfolders to the Templates folder. One way to find your templates folder is to type ?Application.TemplatesPath in the Immediate Window of the VBE.
If you have more than one version of Excel on your computer, Excel will show the contents all your Templates folders in the New dialog, even those from previous versions. Note that in my Templates folder that there is no Spreadsheet Solutions folder. It does exist, however, in the Templates folder of my Excel97 installation.
I’ve added a new folder called Dicks Templates. This folder will show up as a tab on the New dialog, but only if there is at least one Excel template in it. Once I put a template in it, the New dialog looks like this: