filter table and copy unique value to mulitple sheets

hi everyone,

I am trying to build a macro that will loop through filters and copy the unique values to sheets based on the filters. I've seen a few codes based on unique values and copy but can't seem to find one matches my needs.

example:

sheet 1 - in cell A1 I have a list of countries.
A1 - Canada
A2 - USA
A3 - Asia
A4 - Europe

Sheet 2 - this is my data tab with a table. my Table range is from D5:O5. column J is countries

Sheet 3 - Canada
Sheet 4 - USA
Sheet 5 - Asia
Sheet 6 - Europe

What I'm trying to do is on sheet 2 filter column J from Sheet 1 and then copy the unique values of column E and paste it in A1 of the corresponding sheet.

ideally a for loop that will check how many countries and then filter each one in sheet 2 and copy the results to the correct sheet.



any help would be appreciated.