Extract data from multiple sheets

[falconx]

Hello,

Could you please help me to find out which function should I use for below:

I got multiple sheets with same layout.
First column is always date, second and third is text.

And I want in separate sheet find specific text in column B (this text appers in every sheet more than once) and extract row above this text from every sheet.

Thanks
Falconx