Dynamically create checkboxes based on listbox selection

[IAmNomadic]

I have a data validation list with a number of options in it (for the purpose of this question will consider it populated with "option a", "option b", "option c", and "option d"). On another worksheet called "Lists" I have a set of data that looks something like this:

Option 1	Option 1 Q Drive	Option 1 SC Drive	A Drive
Option 2	Option 2 Q Drive	Option 2 SC Drive	A Drive, C Drive, D Drive
Option 3	Option 3 Q Drive	Option 3 SC Drive
Option 4	Option 4 Q Drive	Option 4 SC Drive	B Drive, C Drive

What I would like is to have an area where when I select an option in the list it populates said area with all the options (if any) from the 4th column as checkboxes to select from. The number of checkboxes to select from can change from option to option but shouldn't be greater than about 10 checkboxes. Note that I can re-organize the above table if necessary (it's structure isn't set in stone and can be changed if needed).

[IAmNomadic]

Looking around it seems that the better way would be to have a dynamically changing listbox instead of a bunch of checkboxes. If anyone knows how to do that that would rock.