I know how to make hyperlinks that link to websites and documents on other
drives. My question is:

Is it possible to create a hyperlink that links to another worksheet within
the SAME* workbook? Is it also possible to have the information pop up in a
new window? For example, i want to create a hyperlink in sheet1 that links to
information in sheet3 within the SAME* workbook. Then, when i click on the
link in sheet1, the reference information in sheet3 appears in a new window.

*Im not yelling. There's no option in this post for bold, so i just used
uppercase.