Searching keyword

Hello,

I hope I'm clear enough....

I was tasked to create a database of questions and responses in excel. What I'm trying to do is for the user to "type" in a keyword in cell A1 for a question they need to answer. (for exemple: what is an apple?, they could type "apple" in cell A1).

These questions and answers are to be hidden into another sheet.

I would like all questions that has "apple" in its text to show up in cell B1, C1, D1, etc. From there I will do a vlookup in cell B2, C2, D2 to get the answer.

I'm not certain if I am missing information in my question... please let me know!