Urgent Macro help needed !

I need to generate the waterfall model which is specified in the excel sheet attached.I am done with some part of it,but I am not sure how to plug in the exact values from the two sheets and generate the model.........
It would be kind if you'll can have a look at it and give me some suggestions.I need to write a macro for this.Is there some ready macro available ?????

Waterfall1.xls is attached !

Reply awaited.....Thanks for your time and consideration..Have a nice day ahead !