I have a working subroutine that creates a set of hyperlinks in a 'table of contents'.
Unfortunately the hyperlink that is created is not working, in a few cases.
Context
Example reduced in size for clarity
Workbook with five tabs and the table of contents tab
Workbook worksheet names...