You want to change D1, and have that action cause the value from B1 to be copied to A1? You're going to need a macro for that.

It might be helpful to see what your whole problem looks like. The way I do this is to add a new row for each month. Then A2 looks like

=B1