Autofilter, copy, paste in tabs

[mgnickel]

Hello,

I am looking to make a macro that cannot be solved by recording a macro, because it needs a loop. I am attaching a similar dummy workbook. Here are the steps I am looking to take:
1) Autofilter row 1 in "workbook" tab
2) Select the autofilter in A1 in workbook tab, choose the first name that appears (ie: John), copy all data.
3) Insert a new tab, paste data, name the tab "John"
4) loop steps 2-3 until there are no more names in the autofilter

-Based on the attached example, I want to end up with 3 new tabs that have the data from the autofilter on the first tab.

Thanks!
Mike

[watersev]

hi, mgnickel, please check attachment, run code "test"

[mgnickel]

This looks great, just a couple more things, can you make it so that it only copies the data in columns H-U, including headers?

[watersev]

please check attachment

[mgnickel]

Thank you so much! You are great!