Use a button to transfer filtered data to destination cell

I'm wondering if it's possible to use a macro to create a button to copy and paste filtered information on Sheet1 to a specific destination on Sheet2? Sheet1 contains two tables that can be filtered through many columns. Whatever combination of filters used I'm trying to use a button to copy the visible filtered data in both tables to cell A2 on Sheet2. I want to avoid copying the headers for both tables.

I've attached a sample sheet. Sample 7.xlsx

Thanks in advance.

That's brilliant, thank you. Is there a way to edit the button as it seems to be locked?

Ah right of course, I should have known that. Developer tab's new to me. Thanks again, that's been a huge help.