Data copy paste loop

Hi There

I am fairly new to the world of excel vb, was wondering if you could provide some help please. From the attached spreadsheet, I have a pivot table. What I like to do, via vb, is be able to select every item from the I:1, pivot table dropdown filter, one at a time and loop through, every time value changes in I:1, updates the pivot and copy range H3:I12, then paste to another workbook TEST "SHEET1". Loop back to attached file filter B:3, copy paste same range and paste to another workbook TEST "SHEET2" and so on so forth.

Please can some one help.


Many thanks