Cell referencing help

A'righty, I will attach my workbook. This is for my midterm project.

In worksheet 'budget overview' I need to reference the projected and actual expenses from the total on worksheet 'expenses' So i did so, however, if I change the drop down on the expenses worksheet to only display housing data, then the projected and actual expenses on my budget worksheet changes as well to the new data portrayed on the expenses worksheet.

I need to reference the cell, without it changing when I change the category display, but I need the cell to change accordingly if I enter new data in the overall tablet on the expenses worksheet.

Or do I need to create a seperate worksheet that has the data in and reference my cells on my budget worksheet to that new worksheet?

I hope that made sense!

ps: I'm well aware of spelling errors, I will fix them all when the workbook is finished.


Budget Project Again.xlsx