Formula Will Not Refresh New Data

This may be something very simple, but i have a table which collects varying data from different worksheets to finally calculate a Work in Progress result. Each line on the table consists of the same formula, and certain columns are used to changes %s which change the result.

When the data is changed, the formulas work through and update the new values with no problem until the last couple of columns. With these i am finding I have to copy and paste the formula back into the same place to refresh the data. The formula for those cells which causes the problem are:

Column X:
=IF(AE87="TRUE",(IF(G87>100,100,105)),(IF(AE87="Y",F87,(VLOOKUP(G87, lookup,2,FALSE)))))
Column Y;
=+W88*X88/100
Column Z;
=+U89-H89+Y89
Column AA and AB and AC:
No formulas
Column AD:
=AND(W87<0,X87>70)
Column AE:
=TEXT(AD87,1)

I have checked in the options and the calculation is set to automatic which I presume can cause these problems.