Page numbering different pages on the same worksheet

I have 4 pages in the same worksheet or tab. I have the pages arranged horizontally across in a row. I want to number the pages like "Page 2 of 4". But the numbers keep coming out wrong. I made the fi...