I am in the process of creating a spreadsheet with multiple worksheets. I want to use hyperlinks to jump from data on one sheet to more detailed/related data on another sheet. This works great until some of the data is sorted. The hyperlinks refer to the original cell not with the sorted data. I then tried using the match function to find the row and indirect to get to the actual cell. This works as long as the data is only sorted on the primary column. When sorted on other columns the match comes up with #VALUE.

Example:
Sheet1
John
Bob
Don
Steve

Sheet2
Name Sales
John 5,000
Bob 4,000
Don 3,000
Steve 2,000

After sorting Sheet 2 on column a (Name) the hyperlinks won't work. Using match Sheet2 always has to be sorted on Name. Currently I am using Excel 97 and 2000. Does 2003 solve this?