Search row with criteria in all sheet, copy rows and paste in new created sheet

Hello.

What I want is that Excel search in column E in all sheets (in this example abs, cbr, bmw or even more if more sheets exist) all rows with criteria a as team (or others if needed), copy the entire row and paste all founded in a new automatically created sheet in the same workbook, which is named like the search criteria (here as a)

I'm very new in macros vba so can anybody help me?

Thanks in advance for your help

Try the attached.

Hello AB33.

Thanks for your reply, but how can I change the search criteria of column "E" ?, and why the new created sheet is named MASTER and not like the search criteria?

Do you mean the sheet name should be the same as the search item?
Read the comment on how to change column E.

Hello AB33.

Is it poosible to add a msg box to change search criteria in column E?

Will it be a single column search?

Sorry for my late repy.

Yes it's only for column E. As you can see in column E you have more than one team. So I want a msg box where I can enter the search criteria of column E.

Amended code.

Hello,

can anybody help me?

No help available.