When you create a hyperlink for the first sheet and press Enter, all the sheet columns will automatically update with their hyperlinks. If not, you can simply drag the fill handle to apply the ...

Use Excel’s shapes, text boxes, and icons to design the layout of the sidebar. Add hyperlinks to each element, allowing direct navigation to specific worksheets.