sequentially assign a single number to each worksheet

[tombeaty]

What I need to do is: sequentially assign a single number
to each worksheet. This worksheet number would be along
the same lines as a Page number. Preferably included in
the footer. This number will need to remain static even
if the worksheet should grow beyond a single printed
page. The number will only increase by one when the next
worksheet is printed.

Any thoughts on how I could accomplish this?