Page numbers on various worksheets
 

I am using Excel 2007 and have various worksheets that I will print out one
after another. Basically I want to put custom page numbers(different from the
rest) in the footer of each page of each worksheet. I can use the different
settings in the footer design to make the 1st page different and the odd and
even pages different so that up to the 3rd page of each worksheet can have a
different number (1-1,1-2,1-3) but when I want to put a different number on
the Fourth page it matched it with the second page. If I remove the
"different odd & even pages" option it makes page 2,3 and 4 the same number
and page one remains the same. It is very frustrating not to have an option
to make all the pages have a different footer. Does anyone have a solution to
this?