How to maintain formula/link as I reorder cells via sort?

Hello   I have searched for the answer to this problem but keep getting how to create a constant which is not exactly what I need. So am posting it as a question... hopefully someone can help :)  ...