Hi all - new post

How can I, if possible, get "Page x of x" to appear in a cell, determined by how many worksheets are in the workbook

I.E.

I have a workbook of 27 sheets and I want a text to appear in cell G70 which will automatically read "Page 1 of x", "Page 2 of x" and so on, and will change automatically if I subsequently decide to add more pages

I don't mind if the formula is hidden in the worksheet somewhere, just need to sort this as it's doing my head in!

Any help from an Excel whizzo genius would be appreciated

Thank you, Merci, Danke and so on

David