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 first page separate and manually typed in Page 1 of 4 but I can't get page 3 and 4 to say 3 and 4. And every time I change the footer to say Page 3 of 4 it then repeats on the second page. Any help or tips would be appreciated.