Split data into workbooks and send as attachment in email

Hello,

I have a workbook that contains loads of data that needs to be split into multiple workbooks based on 1 column (in this case Column F of the attached workbook).
After the data is spilt into workbook they need to be sent to the receipient by email (outlook).
The attached sample workbook contains a "Master Sheet" that would provide the recipient To list, recipient CC list for each unit and also the email body based on whats typed in the cells. Column F and Column G in the MasterSheet would be marked as Yes or No. incase Create and review is Yes and Create and send is no the emails should only be created but not be sent where as if Create and review is No and Create and send is Yes the emails should be automatically sent to the recipients. I hope I'm making sense.

please let know know if anyone has any queries.