Get A List Of Sheet Names using TEXTAFTER Function

When you have a workbook with a large number of sheets, it’s very useful to create a list of sheet names as a TOC with forward and backward navigation.
I am Nabil Mourad
Sometime ago, I created 3 tutorials to show you how to extract a list of sheet names either by using classic functions, power query or VBA.
You can watch these tutorials by clicking on the corresponding links here below:
List of Sheet Names using Classic Functions
List of Sheet Names using Power Query
List of Sheet Names using VBA
In this tutorial, I create the same functionality using TEXTAFTER, a new Dynamic Array function , which is much easier.
To Create the Forward & Backward navigation watch this tutorial at 9:33 minute

To create the forward and backward navigation you can watch my tutorial, link is in the description below the video.

[axion]

At once, both concise and comprehensive. Your ability to frame the challenge and the solution remains unsurpassed.

[michaelt]

This is beyond useful. Spectacular timing for me personally. I had no idea the list formula is possible! Thank you!!

[UpExcel]

Excellent! Lovely bit of Excel 4.0 Macro language slipped in there too. I've not seen a simpler way of getting a list of sheet names than this 👍

[stevew]

Another great and easy to follow video, thank you. Can you make this list choose just non-hidden worksheets?

[IvanCortinas_ES]

That's great, but I prefer the Power Query method. Thank you Nabil!

[JoseAntonioMorato]

Dear Nabil,
I made a small alteration in your formula, changing the TRANSPOSE function to the TOCOL function:
=TEXTAFTER(TOCOL(MySheets), "]") 🤗

[X_Forex_Trader]

السلام عليكم من اللكنه باين ان حضرنك عربى غالبا الاسم كمان مصرى
تنصحنى ايدا منين فى تحليل البيانات وخصوصا ان اللغه الانجليزيه مش قويه
احتاج منك نصيحه ان سمحت طبعا