I have a Mac Excel and I'd like to say I am proficient in Excel, but this is one thing I am having difficulties in that I was hoping you guys could help me figure out in either something I haven't seen before or using Macro; I have never used Macro.

I have a worksheet (all in one sheet) Columns A to Z with 5001 rows. I want to be able to find key words like, "pharma" "industry" "bioscience" and the like in all the columns. However, many of the columns may contain multiple words, "ABC Pharmaceuticals" and sometimes it includes pharmaceutical or pharmaceuticals with an "s". So I want it to be able to distinguish between plural and singulars too.

Once the "program" is able to find all these key words in the columns, I would like it to highlight those rows and copy it into a new sheet, "Sheet 2".
Is there an easy way to do it on a Mac Excel or do I have to use Macro? If Macro, exactly how do I navigate to the proper section and what code do I utilize?

Any and all help is appreciated.