I have worksheets listing score totals for individuals in a tournament. Some
people are in more than one tournament, hence, more than one worksheet.

When I create an +overall" worksheet that links to the separate tournaments,
I can add all the points together for people who are in more than one
tournament, but when I sort the orginal worksheets, it messes up the order in
the "overall" worksheet.

Is there a way to make the linked cells stay where they are out? I have
tried naming cells and making them absolute, but a sort in tournament 1,
moves the "overall" cells in column 2, but not the other cells in that row.