I am wondering if a hyperlink could refer to data associated with a RGA #,
similar to how a VLOOKUP uses a reference number. Basically, I want a
hyperlink to not only go to a different sheet in the workbook, but also be
able to refer to the information that is associated with that RGA #.

In a different sheet, I use a VLOOKUP to fill in the blanks of a RGA form
that I made. The information changes along with the RGA # that is referred
to. I would like to have this capability with a hyperlink. By clicking the
hyperlink RGA #, it would go to the RGA form and fill in the necessary
information associated with that RGA #.

Is this possible? I hope i worded this properly. Thanks for your help!!!
-Scott