Thread: Continually populating from one worksheet to another

I have created a "Register" worksheet and a "Budget" worksheet in the same document.
Under Register I have a drop down box in Column D with 7 different choices and the dollar amount in Column F.
What I want to know how to do is to continually populate under Budget whatever goes into Column D plus Column F of Register. I want this to update once information is entered into a field - not me highlighting and adding a formula aftwards.

For example:
Under Register, I choose Dining Out from the drop down list under Column D and enter $20 into Column F on row 2.
Under the Budget worksheet I want the $20 to populate under a Dining Out category, either in another spreadsheet, or in a chart that will show total amount.

on the same token if I go down to row 3 under Register and I chose Gas from the drop down list under Column D and enter $40 into Column F I want it to populate the $40 under a Gas category in Budget.

So the Budget worksheet will have 7 different categories - each with a total dollar amount as retreived from the Register worksheet.

Does this make sense?
Please keep in mind that I am Moderate in Excel and Amateur in Macros.

Thank you for any help