yogi_Pull Into Summary Sheet Data That Is Both In Two Other Sheets

Google Spreadsheet   Post  #2215

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-05-2017

question by Justin Chu Lee:

https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/8KOXuradLVA/ZbPnfjqZAQAJ
Finding out if this is actually possibly on google sheets

Hi everyone,

I am working on a google spreadsheet project right now, and I am trying to see if this is possible.

On the sheet I am working on, I have three separate tabs. The second and third tab has a serious of names, separated by first and last name, that number in the hundreds. 

Now I am trying to figure out if there is a way or an equation I can use on the first page that will let me know if there are any names that match on the second and third sheet and if those names could automatically be transferred to the first page. 

For example; if the second and third sheet both have a "Dave Lee" I would like to see that name pop up on the first page immediately when it recognizes that it is the same.

Is that possible? If it isn't, any suggestions on how I can make this task easier for me?

Thank you,

Justin