So you want to type numbers into say D7:D11 for all the months in row 5 and then be able to switch the months around, via the drop down and have those typed numbers automatically move along with the change?

Well, if that is true, then you will need some VBA or you will have to recreate a similar "input only" table on the side and then have this table refer to that one, via lookup formulas..