Hello, I am an Australian-based software developer with significant experience in VBA. I have previously developed similar emailing Macros for office coffee fund invoicing, etc. I will easily be able to create the Macro to allow you to select which engineers to email and to email just their sheets to them.
Note: the MSForms portion of VBA is only functional on Windows, so if you are using Mac, we will need to achieve using a different method, but it is still achievable.
If you have any questions, please PM me.