I need to create hyperlinks from info in one tab of a workbook to a matching
cell on another tab containing more data.

Data on tab 1 will stay in the same row but is a numerical value and will
change daily. Data i want to link to in tab 2 is also a numerical value. I
need to create a hypelink that when i click on relevant cell in column A on
tab 1 it automatically takes me to the matching data in column a on tab 2 of
the sheet.