You won't be able to do this with formulae. You'll need VBA to read the formula, take it apart, identify the individual cell references and so on. Not an easy feat.

Again, your dot is showing because I4 = 100 and D3 = 100, not because the formula in D3 contains a reference to I4.

You seem to want to consolidate amounts from different tables. I'm just not quite sure I understand your data structure. It seems to be flowing in the wrong direction.