How to open another excel workbook to a specific sheet but take the sheet number from a1

[sspreyer]

Hi,
all

how to hyperlink to another workbook to a specific sheet but using a1 to define what sheet to goto.

=HYPERLINK("[C:\Users\osknows\Desktop\Book2.xlsm]Sheet3!B4","CLICK HERE")

Here's what have tried but im out of my depth

=HYPERLINK("[C:\Users\osknows\Desktop\Book2.xlsm]Sheet=a1!B4","CLICK HERE")

thanks in advance

shane