How to retrieve email addresses from another Excel Sheet

Sheet 1.xlsx (9.9 KB)
Sheet 2.xlsx (9.1 KB)

For reference, thanks!