Hi guys, new to all this so please be patient!!

I have an inventory worksheet which is used as base data. This inventory is
sorted using 2 cols. The data within the inventory is populated to other
worksheets to using this formula =inventory!$k$52

The problem I'm having is when the inventory is re sort and the above data
that was in K52 above moves to say K55, I would like the other worksheet to
track the data rather than the cell.

Can this be done...I hope so...thanks to anyone who helps me out...