I have two worksheet: one with the table of data, one with select feats of this data.

I want my macro to:
1. Copy the cell (feats worksheet)
2. Open the table worksheet
3. Paste the value into a filter search (the macro doesn't adapt to the value in the clipboard)
4. Sort by another filter
5. Copy the the top 10 visible results (the macro doesn't seem to do this. Just does the values that happened to be copied originally)
6. Paste the result 2 cells down from the original cell, as values

Here's the code without 3 & 5 implemented

HTML Code: 
- Where you see 'Arsenal FC', I would like it to just paste the value that I copied initially.

- I want the range to be copied to be the Top 10 rows (+ header row). This would be "A1:R11" if the values didn't change. Then for these to be pasted 2 cells below the original cell.

How would I modify this to make this work?