Budget type excel help

[k2hunter]

Hi i'm currently trying to figure out how to make a budget sheet where i can pull from a drop down menu and then that once that item is selected it automatically updates on another sheet. PTA Budget.xlsx
I already have the drop downs and each sheet is a different budget group.

The drop down menus are selected and then it will take the amount of money in the adjacent cell and subtract it from the budget on another sheet.. The math part i got but i can't seem to get the sheets to automatically calculate once the drop down is selected.

thank you in advance!

[k2hunter]

The drop down menus are selected and then it will take the amount of money in the adjacent cell and subtract it from the budget on another sheet.. The math part i got but i can't seem to get the sheets to automatically calculate once the drop down is selected.