On May 4, 5:09 pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Ryan,

The Workbooks.Add method allows you to specify the template: save your
template file as a template (xlt extension) then use

Workbooks.Add "C:\Folderpath\Template.xlt"

If you want to use a specific worksheet, you could store the worksheet in
the file with the macro, then copy that sheet and add the copy to the new
workbook as the basis of your sheets.

HTH,
Bernie
MS Excel MVP

Here is the current code I am working with,
and I want to use a template sheet called "TEMPLATE". Thanks again
for all your help Bernie!

All this seems to do is copy my template as an additional sheet in my
workbooks. It doesn't use it as the basis of the creation of the new
sheets. So I end up with whatever number of sheets is automatically
generated, then a sheet called TEMPLATE at the end.