There's some notes here
http://excel-it.com/excel_templates.htm
The example Summary workbook shows how to have a hidden "template" sheet in the workbook & using code create a new sheet from the template

http://excel-it.com/workbook_downloads.htm