Trying to set up a hyperlink to reference another location in the same sheet.

Used the example in Excel as a model to set this up so placed this formula in cell B1:

=hyperlink([Book1]Sheet1!a1,"LINK")

this defaults to =hyperlink(Sheet1!a1,"LINK") since Book1 is the current wb.

clicking on "link" in cell B1 produces "Cannot open specified file" error.

I need the hyperlink to be dynamic, so I can't use the CTRL+K hyperlink function.

Thanks in advance for any help