Using a formula to transfer information between sheets, in different rows

I've attached a sample workbook.

I have a list of names with some background information. Three sheets, each representing a different time period and different test score.

On the first sheet, I have painstakingly collected the email address of each person. I've attached a few, but it's actually a few hundred.

On the second sheet, I have a few email addresses, but not all of them. However, there is some overlap in the names, so I may have already looked up the email addresses for some of the names in Sheet 1. So as you notice, Jet Li is already on Sheet 1, in Row 6. I would like to arrange it so that in Sheet 2, *if* the name is already in Sheet one, insert the email address. Note that on Sheet 2, Jet Li is on Row 11.

I also have Sheet 3, which may have some overlap with the first two sheets. I want to insert all the email addresses, if available, into the third sheet. So note that on Sheet 3, Jet Li is again there in Row 11. So is Tanya walker, who was in Sheet 1, and Vince Brood, from Sheet 2.

Note that names are in different rows. That's what I'm having trouble getting over, since the IF formula works if it's in the same row.