MACRO filter, copy paste based on reference criteria

[alkaline55]

Hi there, hoping someone has seen something similar and knows the proper approach to this problem

I have a master workbook with 3 data tabs and 3 corresponding blank tabs. Each data tab has everyone's data by Name in the same column. I'd like to filter each of the 3 data tabs by Name, paste those values onto the 3 corresponding paste tabs, and save a copy of the workbook with the Name. I have attached an image of one data tab as an example.

The process is like this:
Filter Data1 for the first Name
Paste those values onto PASTEData1 tab
Filter Data2 for the first Name
Paste those values onto PASTEData2 tab
Filter Data3 for the first Name
Save down the workbook as Name.xlsx
Repeat for Name 2

The reference criteria could either be a Name tab with each unique name, or a loop that goes one by one finding each unique value in the column.

Thank you

 

[Fluff]

Duplicate Filter for value, paste into a new sheet, and save down copy

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).