Right click on the cell you want to link from

– select “Hyperlink…”

• Click on the workbook / spreadsheet workbook you want to link to
• Click “Bookmark…” button on the right hand side of the navigation box
• Then select the specific worksheet you want to open the book in