You might also try to print those sheets in group mode, where you select all of the sheets and then print them. I know from experience if you have set the footer to print using this custom footer
Page &[Page] of &[Pages]
it will number the pages for all sheets in group mode consecutively.