I'd drop the insert|hyperlink version of the hyperlinks and use a worksheet
formula in an adjacent cell:

If your worksheet name were in A2, you could put:

=HYPERLINK("#"&CELL("address",indirect("'" & a2 & "'!A1")),"Clickme")

Then make sure you include both columns when you sort.

Andybanker wrote:

Worksheet 1 is a table to list up to 100 prospective customers. Worksheets
2-101 are prospective customer profile forms. Each name cell on Worksheet 1
is hpyerlinked to a unique profile. The problem is when I re-sort the list
of names on worksheet 1, the hyperlinks remain with the cells and do not
"follow" the new location of the name caused by the sort. How can I get a
hyperlink (or some alternative) to stay with the row as it gets resorted?

--

Dave Peterson