Ranking by multiple lists

Hi there,
I was wondering if someone would be able to help with something I have been trying to do for a while and that is to create a ranking report where the user can select what items to choose and choose from two seperate drop down boxes to choose what to rank by.

That probably doesn't make any sense but hopefully the attachment shows my issue.
I would like the user to be able to select the region / market they want to view in B2 and then be able to choose (from the drop down boxes) in B4 and B6 which data they would like to rank by.

I would also like there to be a total row (at the top if easier) so if you select region A then you get a total of region A or if you select South Market then you would get that total.

The lists are on the lists tab and the data is on the data tab.

Any help on this one would be so appreciated

Thanks,

SamMultiple Rankings.xlsx