A useful function to learn is how to create an Excel hyperlink to another sheet using a formula.
The function to use is the HYPERLINK function. One of the problems with hyperlinks is that it expects the exact path where Excel files are often stored in various folders and move around. This creates a problem even for internal links.
To make this work you need to put a ‘#’ in front of the address part of the hyperlink function. Easiest way to do this is with the CONCATENATE function.