Chris,

After getting real close to a solution I gave up and found
an answer from someone quite good at this sort of thing,
Doug Robbins.

Here is the (modified) text he posted to a very similiar
question:

To get the numbering that you want, you are going to need
to put a bookmark at the end of each Section which in the
following code I have assumed to be named Sect1 for
Section 1, Sect2 for Section 2, etc.  Then to get the
numbering in the first section you would need to insert
the following codes:

For header use Page { PAGE } of { SectionPages }
For the footer { PAGE } of { NUMPAGES }

In Section 2, the codes you will need are:

For the header Page { =({ PAGE }-{ PAGEREF Sect1 \h }) }
of { =({ PAGEREF Sect2 \h }-{ PAGEREF sect1 \h })}
For the footer { PAGE } of { NUMPAGES }

In the above, the following codes can be inserted from the
Insert Fields
menu item:

{ PAGE }
{ NUMPAGES }
{ SECTION PAGES }

{ PAGEREF Sect1 \h }

is inserted by inserting a cross reference to the page
number of the bookmark Sect1

Though they can also be entered by typing the text inside
braces {} which must be inserted by using Ctrl F9.

Of course this gets more laborious as the number of
sections grow.