The following code will copy the sheet2copy to the target workbook (as a new sheet)
Sheets(sheetname).copy after:=Workbooks(target workbookname).Sheets(1)
I just figured this out! I copied my Template into 3 different directories (i.e. Drive\Program Files\Microsoft Office\Templates\1033 and 2 other that had pre-installed templates). Then I right-clicked on the sheet tab and selected "insert" and my template was there!! Hope this helps you...