Let say have 4 sheets ( from sheet 1 to sheet 4) and in sheet 5 I have a formula which is very complex. So I'm going to give a simple example what I need.
In sheet 5, I have C3=Sheet1!A1 and D3=Sheet1!B1. The addition of C3 and D3 is in cell E3. So in Sheet 1 when I write in A1 and B1, the answer appears in cell E3 of sheet 5. Then I have cell A12 of sheet 1=Sheet5!E3. So the final answer appears in cell A12 of sheet 1.
Now I also need that In sheet 5, I will have C3=Sheet2!A1 and D3=Sheet2!B1. So again the addition of C3 and D3 is in cell E3 and again I need that cell A12 of sheet 2=Sheet5!E3.
So my first problem is that I can't put 2 formulas in one cell. Second problem is that If I update sheet 1, cell A12 of Sheet 4 becomes equal to cell A12 of Sheet 1.
So all I want is that when I populate cells A1 and A2 of sheet 1, answer does not affect cell A12 in Sheet 2.