VBA Data Validation - Multiple selections, each column has its own validation list

Hi all,

I wanted to set up a VBA to set data validation for my daily work. But I'm too new to VBA so I couldn't write a more complicated one to meet my rather complicated need. I could manage to create multiple choice validation VBA but couldn't fulfill other requirements. Could you kindly help?

My issue:
- A workbook containing 02 sheets. "Sheet 1" is in fixed format with 6 columns. Columns B, D, F require to apply data validation. All columns require multiple selections and each selection is separated by a ";". Each column has its own corresponding validation list listed in 2nd Sheet - "Validation Lists". Data in Validation Lists columns is not fixed, additional criteria may be added later.

- Column C will be auto-populated based on what is selected in column B; Column E is based on column D. Values for Column C and E are also listed in Validation Lists.

- And I would like to enable this VBA for similar workbooks with the same template format in the future.

Please find the sample template in attachment.

Thank you very much for any help or advice