VBA required!?

[Morrigan]

I want to setup a spreadsheet to calculate water savings. Attached is the file for the month of July. The way I have it setup right now is that when I change the year in cell "B5" (1993~2002), saving will be output in cell "B4". Then I would manually transfer this number into cells "E3:N3" with respect to the corresponding year.

What I want to do is instead of having to do it manually everytime, I want excel to automatically output these values into "E3:N3". ie. "B5" is no longer an input, input is predefined in cells "E2:N2", output will then automatically be calculated and inserted into "E3:N3".

Hope I am clear, any help is appreciated.

Thank you