Excel 2007 : Vlookup help with merged cell data.

Hello everyone, I was wondering if I could get some help with this.
I am trying to be able to read all the email addresses from 1 worksheet to another.

Emails = All emails where Sheet1(FirstName + LastName) = Sheet2 (FirstName + LastName)

problem here is that Sheet1 has merged cells that can vary by amount of emails.
I have attached a workbook containing two sheets displaying my issue.

I have tried VLOOKUP but it looks like it can only manage to pull the first email not a range of them.

Any help is very much appreciated.