Link Worksheets to Master Sheet in Excel 📊

The VBA program to create a 'Table of Contents' in Excel Workbooks is explained in this video.
Executing this program will add a new worksheet with hyperlinks to every Worksheet of the Workbook. So, this method is a perfect solution for linking every Worksheet of a Workbook to a Master sheet.

👉 VBA Code for creating Table of Contents in Excel
Sub TableofContents()
Dim a As Worksheet, b As Worksheet
Dim c As Range, d As Integer
d = 1
Worksheets(1).Select
For Each b In Worksheets
If b.Name = "ToC" Then
Application.DisplayAlerts = False
Worksheets("Toc").Delete
Application.DisplayAlerts = True
End If
ActiveSheet.Buttons.Add(400, 75, 75, 25).Select
With Selection
.OnAction = "Temp"
.Characters.Text = "Master Sheet"
End With
ActiveSheet.Next.Select
On Error Resume Next
Next
Sheets.Add.Name = "ToC"
Range("C3").Select
ActiveCell.Offset(-1, -1).Value = "S No."
ActiveCell.Offset(-1, 0).Value = "Sheet Name"
For Each a In ActiveWorkbook.Worksheets
If ActiveSheet.Name NET a.Name Then
ActiveCell.Offset(0, -1).Value = d
ActiveCell.Hyperlinks.Add Anchor:=Selection, _
Address:="", SubAddress:="'" & a.Name & "'" & "!A1", _
TextToDisplay:=a.Name
ActiveCell.Offset(1, 0).Select
d = d + 1
End If
Next a
Columns("C:C").EntireColumn.AutoFit
End Sub
Sub Temp()
Sheets("ToC").Select
End Sub

🍐 Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
🍓 7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
🍏Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
🍇Check these Books on Excel - https://xlncad.com/excel-resources/
🍉Read my articles on Excel - https://xlncad.com/

☕ If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
👉 buymeacoffee.com/ajayanand

Subscribe to @XLnCADMalayalam for Excel, Word, PowerPoint, Access, Python and Power BI Tutorials in Malayalam.
https://www.youtube.com/c/XLnCADMalayalam

📢 Disclaimer: If you click on my affiliates links, I am going to receive a tiny commission. The products that I advertise are the ones I believe in.
🏃‍♂️ My Running Kit for Hyderabad Marathon 2025
https://amzn.to/44IILeG
📊 Think Like an Analyst: Books That Helped Me
https://amzn.to/3SNy6bi
📚 Mind-Opening Reads You Can’t Miss
https://amzn.to/43tM2fu

#hyperlinkexcelsheet #excelvba #tableofcontents