Formulas lose reference after macro is executed

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.

If you're deleting the sheet then you will always lose formula references to that sheet.
You will either need to use INDIRECT in the formula wherever you refer to a sheet that will be deleted, or re-enter the formula with the macro after the sheets are recreated.