Task for Excel experts

Hi everyone. I need help with extraordinary task for me.

The Metric formula is referencing A1 cell (A1 cell is a celector). So, the values depend on value that is chosen in A1 cell. I need to fulfill table that is under it (the example of fulfilled table is next to it). It would be easy to do by copy paste formula to E11 cell and make reference to D11. But there are hundreds of other calculations in other places that reference A1 cell, so their values depend on it. And then metric formula references these calculations as well. 

Does anybody know how to do that? I will be pleased for any help.  I hope everyone has a nice day.