It doesn't, because as soon as I sort the individual score worksheet, the
totals worksheet pulls the data from the !A1 cell, which now has another
contestants name.

What about naming the cells, and doing something with that???

"Paul B" wrote:

Barb, something like this should work, =Sheet2!A1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
I have 1 worksheet that needs to pull the scores from several other
worksheets.

Problem is... the other worksheets change order depending on top score
(which I sort manually), so I can't put in an absolute reference to the
other
worksheet cells, because it would give me the wrong number.