List Tab Names in Google Sheets Using a Custom Function

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.

[Wandernitka]

I've used something similar before, to make a list of all tab names in a single google sheet. I wonder now if it would be possible to somehow call a list of names of tabs which contain a certain keyword?

[gregorioh]

Great tutorial!! One question? Each one of my tabs is comprised of a unique "automotive parts" order and when I am done with a tab, I hide it. I hide it as a way of marking it complete but still have access to it if I need to reference it in the future for any reason. I noticed that the table of contents still shows the tabs after they have been hidden. Is there a way to make those hidden in the table of contents after I manually hide them? Hope this makes sense? Thank you!!

[Zombiedmonkey]

This is an awesome function. It's actually opened up a question or new challenge. I'm using each sheet in a the workbook as a customer work page. All tabs will be identical, there are 2 cells dedicated to text "billed" and the cell next to it has a formula then spitting out a number. Ex C4 (text), C5(number)

Based off of this table of contents function in your video, i'd like to query the billed number cell C5 from each tab automatically as the table of contents grows. The billed number would be populated in your column F as Cells C come to exist.

If you could point me to a resource or one of your video's that'd be great. thank you. I'm a subscriber now.