Printing tab page numbers

[dhlawton]

Hi,

Sorry if this has been asked before.

I have a workbook with multiple tabs of varying numbers of pages.
What I'd like to do is highlight the tabs and print them all as 1,2, 3 etc of total pages numbers for that tab as opposed to the total pages for all the tabs highlighted.
I want to avoid printing each tab individually as there could be 100
I know this can be solved with a macro, but I was wondering if I'm missing a simple setting in Excel.

I'm using Excel for Office 365

Thanks in advance

Dave