Search for specific match and calls the entire row from multiple sheets

Hello,

I'm trying to search for a certain cell text, and bring the entire row containing that text from multiple sheets.
In each sheet, there are duplicate text values, so I need to bring all of them.

I made an example file where aa (in yellow highlight is what I'm looking for) is entered and the green highlight part is generated from sheet a and b.
I been looking at some example with vlookup and index, but I can't seem to find one that combines the duplicated value in the same sheet + multiple sheets.

Is there a certain thing I should be looking in to?
any reference or help is appreciated

Thank you!

See attached file - let me know if you need an explanation of how it works.

Hope this helps.

Pete

Thank you very much!!
I will check these out!!