Copy rows from multiple worksheets based on criteria in column

Hi everybody!

I have searched all over forums and I cannot find answer that matches my criteria closely enough so I could adapt the code to my need as I am total beginner.

I have Workbook with multiple sheets and I want to search through all the sheets and copy rows assigned to each persons name to worksheet with that same person's name. Each sheet has assigned different people according to their name put in column E, and I want to have separate sheet for each person that copies all corresponding data.

I.e. I want to copy all John's tasks from all sheets into sheet John etc. Simplified example of my table attached. Thank you!!

sample.xlsx

Thanks. I get Run-time error '9' Subscript out of range

Found one name missing. But now it seems it has copied only from one sheet- currently opened and it has copied it more times?

Yes it works fine on yours, but I probably am assigning something wrong with the macro? Here is my file working version with your macro that I ran.

Plan novi po projektima_bez passa.xlsm

Sorry found error, I must delete additional data when there are some empty rows in between- that is delete empty rows. Works fine now, thank you!!