How can I programatically configure page numbers based on a worksheet
that has the correct page number for the corresponding worksheet?

Example: Each worksheet in workbook is one page, but the pages change
fairly often. I want to keep a "master page number" worksheet that can
be updated easier than going into each worksheet and setting the
footer.