The formula used to pull the correct info but it is now just repeating what is in BE2 and not pulling what is in BE2, BH2, BK2, BN2 etc
That makes it sound like calculation is set to manual.

Make sure calculation is set to automatic.

Got the Formulas tab>Calculation Options>Automatic