There are 2 ways to do this (maybe more). You can create hyperlinks to the target page or you can create macros. The Macro option will give you the "buttons" I believe you are imagining but, of course, it is a more difficult process to set up and will complicate the maintenance of your workbook.
I'll stat with the hyperlink option and if you really want to go with the macro option we'll tackle that later.
On your button page type into a cell the description of where it will take you
with that cell selected click on Insert/Hyperlink
A pop up will appear with several options on the left. Make sure that "Place in this document" is selected
In the main body of the pop-up you'll see a list of options. under the heading "Cell Reference" you will see a list of you tabs or worksheets. Select the appropriate one.
At the top of the pop-up you'll see a box for the cell reference which is pre-filled with A1. You can change this if the table you are linking to is elsewhere.
Click okay and you should have the link all set up.
If you want to change anything for that link right click on the cell and select "Edit Hyperlink" and you'll get the pop-up back
With a bit of formatting you can get it to look like this
Let me know if you want to go the macro route and if you do let me know what experience you've had with them.