Create new sheets and copy/paste data based on values in a column or columns

How do I write a macro to create new sheets based off the data in certain columns in Sheet 1

So a tab that shows the data from Sheet1, but only where Rico is listed in 'PM First Name' column
Another tab where data shown is only where Rico is listed in 'PM First Name' and his role is 'Project Manager'
Another tab where data shown is only where Rico is listed in 'PM First Name' and his role is 'Sourcing Manager'

I would also like this to be done with the other person listed, Sarah.

So the workbook would be 7 tabs total after running.

Also 'Sheet1' data will continue to amass data and will get bigger which is why I want to know how the macro works versus just filtering and pasting the data in new tabs in the workbook.

Here's how to do Rico. This assumes you want the code to add the sheets if they don't already exist.

Please Login or Register  to view this content.