Retrieve entire row where text string is found in any column/field

[Jqarga]

Hi guys,

I've got a data set with multiple rows and multiple columns and I need to be able to find a txt string across the entire data set. Then it'd be great if I can get a copy of the entire row where the item is found into a separate sheet (The item can appear in multiple rows) ; I'll need to repeat the same process for different txt string items.

On top of that, is there any way of basing the above search into a "approx matching" or at least case insensitive search?

Happy to use VBA/Power query or whatever you think it may work best.

Thanks a lot