excel is there a formulae to do this?

Hello I am trying to make my life a little bit easier, I have several sheets that I would like to extract an entire row using specific criteria in one cell. I am not tech savvy so coding and macros a...