OK - I'm going to try to be clear on what I'm trying to figure out here

I have a worksheet (WS2) that has a number of lists in columns with corresponding results. For example, Columns A - D have drop down lists (year, community, status, month), and columns E-H have corresponding values (target revenue, online revenue, offline revenue, total revenue).

In another worksheet I would like to have a summary page. 4 cells have drop down lists that correspond to Columns A-D in WS2, and I would like to have 4 cells that display the summed results of Columns E-H in WS2, depending on the selections from the drop down lists. I know this can also be done using filters in WS2, but a summary page like this could be more user friendly for those who are not familiar with Excel.

Do I use filters for this somehow, or do I build some complex functions? Any suggestions?