Use a custom function to list tab names with links in Google Sheets. This is convenient when you need to make a table of contents or just want to get a list of all the tabs in a Google Sheet.
You can make a copy of the Google Sheet I demoed in this video here: https://bit.ly/3ZkR0Ln