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.