Loop through two filters and copy a cell to another sheet

Hi,

I'm trying to create a table that shows a certain value between two states.
I have 50 States, so that's 2500 values I need to input and update frequently.

How do I use the macro to loop through two filters (states 1 and 2), extract the value (cell B1), and paste that into the appropriate table cell in sheet1?

For example, if I were to get a value for MI and OH from sheet2, I'd filter column C to 'MI' and column D to 'OH'. This returns 5 results and the resulting B1 value is 2.20. I need to copy and paste this value into sheet1's cell AI22.

I hope this works out.
Thank you.