VBA Dynamic ComboBoxs to be added to an Excel UserFrom

Good Day !

I have some challenge that I try to figure out how to solve.

I want to make dynamic UserForm with depended combo boxes which the first one will be the “Father” combo box but the “Child(S)” are changing rely on the sheet headers.

let’s say that on column A I have list of all the “Father” names and from column B1 onward (C1, D1 etc.’) I have the child of each father.

I need a dynamic solution as I have few files with different “child’s” (i.e: columns)

Is it possible to add differant number of combo boxe(s) to UserForm, as many as the child’s (i.e: Header rows) ?

the UserForm , of course, will have to adjust (resize) according to the number of ComboBoxes

I'm attaching file with already have the depending combo boxs.

appreciate your help !!!

Shlomi