Sending Email Attachments by Data

hello all,

im new here and looking for some help.

bascially, i have a long list of dat for each department which i would like to paste into sheet 1.

this then needs to be filtered by column H (department name) and copied into sheet 2's template.

once in the template, i need to send this to the relevant email address in sheet 3.

this needs to be done for all departments.

please could someone either assist or point me in the right direction.

also posted on

HTML Code: 

but no one seems to respond there...

thanks,

adam