Extract to another table individual data

Attached is the start of a database (some data removed), additional members are added on a daily basis.
What I need to do is to be able to add new members on the first tab and then a macro or something to extract Customer ID and email addresses only and add them to the second tab, therefore creating a 2nd database for email contact only.

Any suggestions?

Would need some help on formula or macros as a bit of a novice and need the brains of you guys and girls out there

This could easily be done with a Worksheet_Change event. I would need to know which column would be the last one to be completed for each name.