Search a table with multiple search inputs and return all matches

Hello All,
I am looking to parse a table of information and based on a search that I enter via a message box, I want to return all relevant data in a message box or a new spreadsheet. I wrote examples in the sheet

Thanks so much!

Need_help.xlsx