Display only rows with matching search results from another column

[Nunya]

I tried to write an explanation of what I'm trying to accomplish in Excel, but can't find a way to explain it clearly, so I recorded a short screen video of my example sheet with explanation. I'd appreciate any help.

Here's the explanation/question video link.

Thank you!

 

[Yongle]

Welcome to the board Nunya

Just wondering, do you really want an extra sheet with the matching items?
Using a helper column in Sheet1 to mark matched items, and filtering with DataFilter returns what you want.

Try this...
In F3 (Sheet1) enter text "Helper"
Place this formula in cell F4 and copy down
=IFERROR(IF(MATCH(D4,Sheet2!$B$4:$B$10000,0)>0,"Yes",""),"")

With cursor anywhere inside the table \ click Data tab \ Filter (inserts dropdown arrows in row3)
In dropdown in cell F3 deselect blanks
Now only matched rows are visible

If you need a separate sheet let me know
- you will either need array formulas or VBA
- best to start with something that matches your real data structure
Q In your "real" datasheet is the first name in cell B4 (and first "info" in B4 in sheet2) ?

 

[Yongle]

This simpler formula in F4 copy also works
=IF(COUNTIF(Sheet2!$B$4:$B$10000,D4)>0,"Yes","")