You can create a custom navigation in an Excel workbook. This post will show you how to click a cell within Excel and jump to another worksheet tab. First click on the cell in which you want to insert the hyperlink. Then click the Insert tab–>Hyperlink.
Click the “Place in This Document” option. Then choose the worksheet you wish to navigate to.
You should get the text underlined with the hyperlink ready to click. In my screenshot example, if I’m on the Summary tab I can quickly check out data in the Jan tab easily by clicking cell B3.