VBA to filter top ten values then paste into the related tables

Hi All,

Extremely new to the forum and VBA. I was wondering if anyone can help me out?

I am looking for a VBA Code that can run through a data dump and filter for the Top ten highest variations and paste the correct data into the related tables.

I have included the worksheet for an example. I also understand this could be done in Pivot Table however I am trying to increase my understanding of VBA.

If anyone could help me with my issue that would be most appreciated

Thanks in Advance !