I'm using Cognos 10.2 and am creating excel output with multiple worksheets. The first worksheet has a list of the remaining worksheets with a report description and I want to click on the hyperlink and go to the selected worksheet.
Add bookmarks to the pages what will be the target worksheets, then on the first page, add drill through definitions on text items that drill to the bookmarks.
https://www.ibm.com/support/knowledgecenter/SSRL5J_1.0.1/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/t_cr_rptstd_frmat_rep_add_bookmark.html