To select the Next page use this code:
ActiveSheet.Next.Select
or the previous one
ActiveSheet.Previous.Select
To go to another page, there's an easier way, right click on the arrows at the left of the Worksheet Tabs, you'll see a list of all your sheets and you can click one of them to go instantly to it.