MACRO filter column based on reference criteria copy, paste and repeat

[helpmeinoob]

Hi everyone, I've been working on this problem for quite some time now and I'm stuck. Hoping this community can provide some very needed guidance to this newbie

I've attached a simple workbook. I'd like to filter Column A on Data1 based on the Names tab, paste into PasteData1, and do the same for Data2 - PasteData2 and Data3 - PasteData3, then save down a copy of the workbook with the Name.xlsx and loop to the next name. So the process is this:


Filter Data1 for the first Name on the Names tab
Paste those values onto PASTEData1 tab
Filter Data2 for the first Name on the Names tab
Paste those values onto PASTEData2 tab
Filter Data3 for the first Name on the Names tab
Save down the workbook as Name.xlsx
Repeat for Name 2 on the Names tab


To note, the three data tabs cannot be combined into 1, my actual workbook is more complicated.

Please help!