Hi all!

Here's what I'm trying to do: I have an autosort function from sheet two
showing scores from my employees. The scores and order of the employees
changes daily, so I'm trying to link the top five into a seperate sheet that
will continuously update as the order from the larger sheet updates.

The problems: the basic "link" function does not link the cell G5 from sheet
2 to B6 in sheet one, rather, it links the contents of G5 in sheet 2 to B6 in
sheet one. So when the sort function of sheet 2 kicks in, the contents in
cell G5 could slide down to G6, but what's now in G5 is not what's linked to
sheet 1, rather, it's what is now in G6.

Is there another formula or coding I should be using?

Thanks,

Orangepegs