So i have a contents page which holds my vlookup
=VLOOKUP(C8,'Content Summary'!1:1048576,2,FALSE)
and a content summary page which holds a full list of sheets and sheet sections in my workbook.
The vlookup on the contents page pulls the correct data but doesn't pull through the hyperlink to...