Hello all

I am new to the forum and new to advanced excel operations. I have a small project that I am working on for my job. It is a spreadsheet that houses a lot of information on part numbers and each part number has a person's initials associated with it. I want to automatically populate a tab for each person's initials and transfer all the part's information from sheet 1 to this sheet. Any help would be greatly appreciated. I have included a sample of what I am working with. Example.xlsx