I have been looking around online and have not been able to find what I need. As you can see below I have a list set up of different capitalization rate percentage ranges.
(Note: the "xx" max/min should be actual rates - I set up this table before I had any of the rates)
I would like to set up some sort of "summary" table on the first spreadsheet, with drop-down menus for each of "Provider" to "Quarter" where I can display only the relevant data. I know this can be attained using filtering, but I don't know how to set up the filter on a different spreadsheet. For example:
The values in the bordered cells would be drop-down boxes, much like when data is filtered in the traditional way.
I looked into pivot tables, but since I need the actual values from the min/max columns I don't think there was a way to do it.
Is there a way to achieve this using basic excel functions? If writing VB is required, I will need specific instructions, as I have very little knowledge when it comes to this. Any help would be greatly appreciated.
Thank you!

(Note: the "xx" max/min should be actual rates - I set up this table before I had any of the rates)
I would like to set up some sort of "summary" table on the first spreadsheet, with drop-down menus for each of "Provider" to "Quarter" where I can display only the relevant data. I know this can be attained using filtering, but I don't know how to set up the filter on a different spreadsheet. For example:

The values in the bordered cells would be drop-down boxes, much like when data is filtered in the traditional way.
I looked into pivot tables, but since I need the actual values from the min/max columns I don't think there was a way to do it.
Is there a way to achieve this using basic excel functions? If writing VB is required, I will need specific instructions, as I have very little knowledge when it comes to this. Any help would be greatly appreciated.
Thank you!