Keep all references unchanged after sorting

[masterton]

Take a look at the spreadsheet.

The references will change after sorting and break the calculations.
Absolute referencing is not an option. The table has to be copied periodically to another sheet and placed it at a different row (the columns are identical). Absolute referencing will break the calculations after copying.

I would like to keep the references unchanged. One idea is to use formulas to maintain references.
For example, S75 contains:
=T70
Change it into:
=(the address of the Count data cell)

What formulas could I use to achieve this?

If no formula could do, I need to resort to macro. Use absolute referencing ($T$70) first. Then run a macro which change all selected cells into relative referencing (T70) every time it needs to be copied. Only the reference of T70 needs to be changed, not any others. I don't know how to code. Could anyone help? Thanks a lot.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1243024-keep-the-references-after-sorting.html#post4962868

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[masterton]

Thank you for your reminder. No solution yet.

 

[masterton]

I have updated the worksheet. Thank you.