Mail variable number of sheets in workbook based on VLOOKUP mail address

Hi

In attachment you'll find my data.

I have a several sheets (which's number can vary all the time), and I need to send the to the corresponding mail address to be found by vlookup.

So I want the macro to open each sheet in a time, look for the LocationCode, link that to the correct mail address found in Email tab, create a new mail with sheet as attachment and then send it out to the e-mail address found.

Can you pls help me out?
Tino XXL