I have (1) workbook with 3 sheets.

If I use column A in sheet 1 to list the following going down the list like this
(A1)Apple
(A2)Boy
(A3)Charlie
(A4)Dan
(A5)Ed
(A6)Frank
(A7)Ginger

And in Sheet 2, I have the same names again, but use colums B,C,D,E,and F for other information (address, phone, fax, email and notes)

Is there a way that I can hyperlink Charlie from Sheet 1 (A3) to Charlie in sheet 3 (Who may now be without going to Sheet 3 to see what cell each contact name is under?

Sheet 3 is really a Master Contact list with 3,000 names that will be added to and sheet 1 may only have 30 names total that need linked. There will be a total of about 10-15 sheets with different names, but the idea is to add the name to any list and be linked to the master list of Sheet 2

Thanks all!! Awesome site.......

Tracy