Page Numbers for an index

[Guest]

I have a large workbook with 15 tabs (sheets).
My first sheet contains a cover page and a list of the other 14 sheets (an
index page).
The intention is to always print the entire workbook at once with continuous
page numbering in the footer.
I would like to add the pages numbers of each of the 14 sheets to the cover
page, but do so in a way that they will be automatically updated if the
contents of the workbook changes and pages shift.

Is this possible?

Thanks for any suggestions.

 

[sulprobil]

See http://www.mrexcel.com/tip017.shtml

HTH,
sulprobil