Open up the attached sheet, and go to the April sheet. This is the finished product; I did a paste special to paste only the values once the functions were done calculating. On the left is the report I want to generate, and the right side of the screen is my raw data. In the May and June worksheets I am using my own variation of dynamic ranges, by having each cell in my report reference the cells M2:U2, and as each month of raw data changes, I simply change the contents of m2:U2 to reflect the changing raw data.
I made a macro such that all I have to type in is the range of the days in cell M2, and press control + K to fill in the rest of the ranges in cells n2:u2. Once I do this, all of my cells work, and the numbers appear like they should. But once it is done executing, The data in cells D2:K4 turns into #value and I dont know why as it worked fine yesterday without the control K macro and I would type in the ranges in cells M2:U2 manually.

To make the numbers reappear in cells d2:k4 I have to manually double click each cell and press enter in n2:u2 to force a recalcualtion.