Auto hyperlink between sheets by same number - maybe macro?
 

I am working on a report that has two worksheets. The two worksheets often
share a common number per line and I am working on linking the second sheet
to the first sheet by this common number. I have been manually adding the
hyperlinks, but each month the number of lines grows and it takes me longer
and longer to enter the hyperlinks. I am needing a macro or some way to have
excel automatically link those numbers in sheet two with the ones that match
in sheet one to save me lots of time (and possible errors).