Copy data from 1 sheet to 1 or more sheets depends on the no of check boxes selected

Hi All

background on the setup and what I want to do:

Columns A to C contains details eg Name, Email, Company.
Columns D to H refers to distribution list, eg Test, Dept A, Dept B - this is where I need to select which list the person belongs to - could be multiple.

So, when I select Test & Dept B for a person, his details (Columns A - C) is then copied to two different sheets called Test & Dept B (these sheets later exported to csv etc as required)


I've been through a few examples found on the net that looks similar but seems the rows only have one checkbox to trigger the copy and not sure how to implement the suggested solutions for multiple check boxes.
I would also like to remove the details from the relevant distribution sheet if I uncheck (and removing the blank like if possible - nice to have).
I'm not stressed about alphabetical sorting in the distribution sheet - can still do this manually (which will resolve the blank line issue as well.)

I have two selection options setup - Check Box linked to the cell, or the Marlett option found on another site.
(The Marlett option is easier that linking cells with the check box)

Any suggestions how to do this? I can upload a sample if required?

PS: All I know about VB code is what I copy and paste and then trying to figure out how to alter for my needs, so please excuse any dump questions from my side.

Thanks!!

Hi

Please find attached a sample (contains the code for the Marlett option mentioned).
I've created the 'client details' sheet which contains the client details and various email distribution he belongs too.
Then created a sheet for each list and populated with the info as per the selection in 'Client Details' sheet. The list sheets I want to update automatically as I tick/untick in 'Client Details'

testing.xlsm

Thanks
Jacques