This video will walk you through how to put together a Table of Contents in your Google Sheets with clickable links to take you to that tab. This does use scripting, but as a custom function so you don't have to authorize the script!
You can make a copy of the final project here: https://bit.ly/3Tkjz7w