If you want to make the macro a little more generalized
you could have your headers and footers as you want them
for the rest of the sheets then have the macro save the
header/footer parts you want to change and then restore
them after printing the first page. (in Ron's macro)
If you wanted to do first page differently with respect to headers,
such as with or without a logo
or no header rows you can do that by using the top rows of
the spreadsheet and doing the rows to repeat later on. And
forcing the page break just before your rows to repeat.
http://www.mvps.org/dmcritchie/excel/logoshd.htm#toprows