Etc is a lot to do (or not).

But this shell may give you an idea of what to do.  It displays a file|open
dialog.  The user can select as many files as they want and then the template
workbook will be added to each workbook--and just the row/column headings are
hidden.

Option Explicit
Sub testme01()

   Dim wksTemplateName As String
   Dim myFileNames As Variant
   Dim wkbk As Workbook
   Dim wks As Worksheet
   Dim fCtr As Long
   Dim myWindow As Window
   
   wksTemplateName = "C:\my documents\excel\book1.xls"

   myFileNames = Application.GetOpenFilename("Excel Files, *.xls", _
                     MultiSelect:=True)
   
   If IsArray(myFileNames) = False Then
       Exit Sub
   End If
       
   For fCtr = LBound(myFileNames) To UBound(myFileNames)
       Set wkbk = Workbooks.Open(Filename:=myFileNames(fCtr))
       Sheets.Add before:=wkbk.Sheets(1), Type:=wksTemplateName
       For Each wks In wkbk.Worksheets
           wks.Activate
           ActiveWindow.DisplayHeadings = False
           'anything else you need here
       Next wks
       Application.Goto wkbk.Worksheets(1).Range("a1"), scroll:=True
       wkbk.Save
       wkbk.Close savechanges:=False
   Next fCtr

End Sub

ps...

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm