You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.

Show users how to create a quick table of contents in Excel using the power of hyperlinks.