I have tidied up your code by making the ComboBoxes load better.
Check this out, I think it is doing what you need.
I have kept your sheet layout
Roy, You are a hero sir, cant thank you enough (and also Carim) can only hope I can work to having your level of knowledge someday. Thank you again