Can I create a HYPERLINK from one WORKBOOK to ANOTHER WORKBOOK? I don't want
just a regular link that returns the value of the second workbook, but I want
users to be able to click on the cell/text and go to that second workbook.

Would it be a MACRO?