Print using "Names" settings

[GareldMcE]

I have a notebook with three sheets of linked data named Est, Progress and
Billing. Each sheet needs to be printed separately with different headers on
each page. If I go to Page Setup/Options and set the Top Heading to the top
row for any one page, then go to Named Settings, select that sheet name, select
update, and select use, I get a proper printout.
However, after I have set up all three sheets, If I then select the Name for
the first sheet, I always get the header for the last sheet that I set up! It
appears that the only thing the Names setting retains/resets is the sheet
header and footer information.

Any suggestions? What am I doing wrong?

It is important that the user not have to do anything more than select a name
and click on Use in order to get a proper printout. Putting a line with header
data every 55th line is not practical since it is not uncommon to add lines in
the middle of the sheet.

TIA

Gareld McEathron
gare...@aol.com