creating hyper link from one sheet to another using macros in Excel

I have a worksheet where the first sheet Is index and the next sheet has details . I have created a macro which will create links from "detailed data" sheet to the "INDEX" sheet (rows can be selected through a text input box). The macro does not seem to work. I have manually created links for C2 and C3 in the "Index" sheet which links it to the "detailed data" sheet. I need the macro to do that automatically based on no of rows selected
Please help