To get the link to a Tab in your Google Sheet:
- Click on the tab you want to link
- Copy the url in the address bar
- Right click (Control + click) on the cell that you want to turn into a clickable link
- Click "Get link to this cell" in the drop down menu
- Share a specific tab within a sheet
- Direct someone to a specific cell in a sheet
- Add a Home button to tabs in your Sheet so you can quickly get back to the first tab
- Create a "table of contents" for your Sheet
- Link to important calculation cells so they can be easily accessed