Is there a way you can have two columns of data on two different worksheets
find each others matching value, then have them become hyperlinks, in the
sense;

Say you have Page001 WS, column A has value 10, and Page002 WS, column A has
a value in the column somewhere as well; can you have them find each other
become linkable then while saying you do a Ctrl F for 10 in Column A you can
click on the value 10 and it will take you to value 10 in Column A of Page002
WS and if you click it again it will take you back to Page001 WS column A
value 10 again? Is there anyway to automate this procedure?

Thanks for your time.