As you have already got separate footers (assuming your page numbers are in the footer), you can automate this further by doing something along these lines ...
In the footer for section 1 ...
[blue][red][tt]{[/tt][/red][tt] Set PagesBeforeSect[/tt][red][tt]1[/tt][/red][tt] 0 [/tt][red][tt]}[/tt][/red][/blue][tt] [/tt]
[red][tt]{[/tt][/red][tt] Set PagesBeforeSect[/tt]
[red][tt]2[/tt][/red][tt] [/tt]
[red][tt]{[/tt][/red][tt] =([/tt]
[red][tt]{[/tt][/red][tt] PagesBeforeSect[/tt]
[red][tt]1[/tt][/red][tt] [/tt]
[red][tt]}[/tt][/red][tt] + [/tt]
[red][tt]{[/tt][/red][tt] SectionPages [/tt]
[red][tt]}[/tt][/red][tt]) [/tt]
[red][tt]}[/tt][/red][tt] [/tt]
[red][tt]}[/tt][/red][tt]
Page [/tt]
[red][tt]{[/tt][/red][tt] Page [/tt]
[red][tt]}[/tt][/red][tt] of [/tt]
[red][tt]{[/tt][/red][tt] NumPages [/tt]
[red][tt]}[/tt][/red][tt] Section Page [/tt]
[red][tt]{[/tt][/red][tt] =([/tt]
[red][tt]{[/tt][/red][tt] Page [/tt]
[red][tt]}[/tt][/red][blue][tt]-[/tt][red][tt]{[/tt][/red][tt] PagesBeforeSect[/tt][red][tt]1[/tt][/red][tt] [/tt][red][tt]}[/tt][/red][/blue][tt]) [/tt]
[red][tt]}[/tt][/red][tt] of [/tt]
[red][tt]{[/tt][/red][tt] SectionPages[/tt]
[red][tt]}[/tt][/red][tt][/tt]
... in the footer for section 2 ...
[red][tt]{[/tt][/red][tt] Set PagesBeforeSect[/tt]
[red][tt]3[/tt][/red][tt] [/tt]
[red][tt]{[/tt][/red][tt] =([/tt]
[red][tt]{[/tt][/red][tt] PagesBeforeSect[/tt]
[red][tt]2[/tt][/red][tt] [/tt]
[red][tt]}[/tt][/red][tt] + [/tt]
[red][tt]{[/tt][/red][tt] SectionPages [/tt]
[red][tt]}[/tt][/red][tt]) [/tt]
[red][tt]}[/tt][/red][tt] [/tt]
[red][tt]}[/tt][/red][tt]
Page [/tt]
[red][tt]{[/tt][/red][tt] Page [/tt]
[red][tt]}[/tt][/red][tt] of [/tt]
[red][tt]{[/tt][/red][tt] NumPages [/tt]
[red][tt]}[/tt][/red][tt] Section Page [/tt]
[red][tt]{[/tt][/red][tt] =([/tt]
[red][tt]{[/tt][/red][tt] Page [/tt]
[red][tt]}[/tt][/red][tt]-[/tt]
[red][tt]{[/tt][/red][tt] PagesBeforeSect[/tt]
[red][tt]2[/tt][/red][tt] [/tt]
[red][tt]}[/tt][/red][tt]) [/tt]
[red][tt]}[/tt][/red][tt] of [/tt]
[red][tt]{[/tt][/red][tt] SectionPages[/tt]
[red][tt]}[/tt][/red][tt][/tt]
... in the footer for section 3 ...
[red][tt]{[/tt][/red][tt] Set PagesBeforeSect[/tt]
[red][tt]4[/tt][/red][tt] [/tt]
[red][tt]{[/tt][/red][tt] =([/tt]
[red][tt]{[/tt][/red][tt] PagesBeforeSect[/tt]
[red][tt]3[/tt][/red][tt] [/tt]
[red][tt]}[/tt][/red][tt] + [/tt]
[red][tt]{[/tt][/red][tt] SectionPages [/tt]
[red][tt]}[/tt][/red][tt]) [/tt]
[red][tt]}[/tt][/red][tt] [/tt]
[red][tt]}[/tt][/red][tt]
Page [/tt]
[red][tt]{[/tt][/red][tt] Page [/tt]
[red][tt]}[/tt][/red][tt] of [/tt]
[red][tt]{[/tt][/red][tt] NumPages [/tt]
[red][tt]}[/tt][/red][tt] Section Page [/tt]
[red][tt]{[/tt][/red][tt] =([/tt]
[red][tt]{[/tt][/red][tt] Page [/tt]
[red][tt]}[/tt][/red][tt]-[/tt]
[red][tt]{[/tt][/red][tt] PagesBeforeSect[/tt]
[red][tt]3[/tt][/red][tt] [/tt]
[red][tt]}[/tt][/red][tt]) [/tt]
[red][tt]}[/tt][/red][tt] of [/tt]
[red][tt]{[/tt][/red][tt] SectionPages[/tt]
[red][tt]}[/tt][/red][tt][/tt]
etc., etc.
The bits to note are the red braces, which are field delimiters entered, in pairs, via Ctrl+F9 and the red numbers, in which I hope you can see the pattern.
The bits in blue italics, setting and using, "PagesBeforeSect1" aren't strictly necessary but they make the whole thing more consistent.
This kind of stuff is very fiddly and you have to get it exactly right, but when you do you shouldn't have to make any more changes unless you want to add or remove extra sections.
I have experimented with using dynamic variable names but never got it to work consistently as I wished - maybe one day I'll be confident to post a version like that, but not today
Enjoy,
Tony
------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
I'm working (slowly) on my own website