Hello, I would like to hyperlink to another sheet using the indirect Reference.

I have this so far but when clicked it says cannot open the file specified.

=HYPERLINK(INDIRECT("'"&B6&"'!A1"),1)
Does anyone know whal else I need to put in to link this cell to another sheet in the same workbook?

Regards,
Tom