Need VBA code to search and display multiple returned values

Hi

I was wondering if anyone can help me out with a problem I am having with excel. I have a spreadsheet of names including 5 keywords for each person. I want to do a search for a keyword and have all the results displayed. Doing the ctrl+f search is not efficient as can only go one value at a time. I want to see all the results at once. Any idea how to do this?

It would be better if you upload a sample workbook exactly similar to your original workbook with some sample data in it.