Hyperlink in an indirect Function

[bubnl]

Dear users,

I having some trouble with Excel.
i'm making a front sheet where i will show all the data from the different sheet. To get the different from the data sheets to the front sheet i use the indirect function. Only now i have an hyperlink on the data sheets which i want to show and make clickable on the front sheet, what doesn't work.

Thank you!!