uniform headers on Excel worksheets

I want to print a worksheet each week from one workbook. I want the headers
to be uniform from worksheet to worksheet without having to enter the text
for each worksheet. Additionally, I would like to have the date of the last
day to pring in the header. Who knows the secret?