Dynamic table of contents in Excel with formulas (no VBA)

Create a table of contents with each sheet's name as a clickable hyperlink taking you to that sheet using formulas only, with the brand new release of Microsoft 365 dynamic Array functions VSTACK and TEXTAFTER, also using the longer time functions, CELL, HYPERLINK and the 3D references formula concept means you only need to list the first and last sheet and every sheet in between will be dynamically included, so if sheets are deleted then its fully dynamic but if new ones are inserted, a small copy & paste adjustment is needed for each sheet.
To download example files, enter email here: https://www.xlconsulting-asia.com/socials.html

Видео Dynamic table of contents in Excel with formulas (no VBA) канала David Benaim