Is there a way to stop the circular reference warnng from happening?

Basically my formulas depend on the value of D4 to where they are looking for the cell value, but my formulas return a circular reference warning, and this is the only way i can figure out exactly what i need. I dont want to add another cell(s) in my sheet and creat unecessary data just to resolve this

Is there a way?

In cell D14

Formula: copy to clipboard 
=IF(D4="Budget",'Volume Splits'!D5,IF(D4="Actual",D20/$D$24,IF(D4="Reforecast",'Volume Splits'!D5)))


In cell D20

Formula: copy to clipboard 
=IF(D4="Budget",D14*D$9,IF(D4="Actual",'Order Summary'!C107,IF(D4="Reforecast",D14*D$9)))