I'm going to simplify the scenario. I have 2 worksheets A & B, Worksheet A
cell A1 has a value of 10. Worsheet B takes this value and Cell B1 is now 10.

Now the question, I want to remove the value of 10 in Worksheet A, but I
want the value to stay in Worksheet B.

Then to make it even worse, I want to put a new value in worksheet A cell A1
such as 5 and have it add to Worksheet B cell B1 making it now 15, so on and
so on.

Is this possible?

Thanks