Populating Data (and Totaling) From One Sheet To Another Based On Selection

[eamurphy]

I have a budget workbook where in sheet 1 I have the main budget line items with months and totals, and in sheet 2 I have the detailed transaction list.

I would like to make it so that when you enter something into the detailed transaction list, it automatically updates the totals in sheet 1 in the proper line.

I have attached the workbook I am working on.

Thank you!

[oeldere]

Maybe with an pivot table.

You can also add data (or month) to the table.