MS Model v1.xlsm

I'm stuck on something. My formulas in columns C-H lose the reference to the 'Close Price' sheet after the macro is ran on the 'Parameters' sheet. The macro deletes all of the sheets except the two core colored ones and then recreates them with the updated stock data.

Does anyone know how to fix this by either altering the macro or the formula in the cells?

Thanks very much.