Create mini table from a bigger table

I have attached an example spreadsheet to explain what I want to do.

In the example, there are three tabs. The data tab has a list. In the first column, we have either Mary or Paul and in the other columns, we have what colours they wore at a given time.

What I am looking to do is create the same list in the other two tabs. In the 'Mary' tab, only the lines for Mary will exist and in the 'Paul' tabe, only the lines for Paul

Can anyone suggest a way to do this?

Thank you

Originally Posted by AliGW

Are you really using the ancient Excel 2000 or something newer?

I'm using 2016

Originally Posted by Sambo kid

easiest way in my opinion without formulas is to place a filter on the data tab an filter on Mary then copy all the cells over and paste them on the Mary tab, do the same for Paul and in a couple easy steps you are done. Took me less than 30 seconds to do that. done without formulas.

I am trying to automate it for others to use without needing to do that.

This is just an example, to try to learn which formula might work. The spreadsheet it is ultimately for has much more data. What will happen is each month, someone will be able to copy and paste a table full of data into the data tab and the other tabs will auto-fill with the relevant data. I will then be able to include a macro that copies it all and pastes the values in, so that they are left with just the separated values without having to do it manually