Sorry speedyg.

I'm stupid and slow. I still do not understand.

Can you breakdown this down into very small steps? Small steps can then be tackled easily.

KEY: SMALL STEPS. Adequate English to accurately define the problem. I KNOW you understand what needs to be done, but you need to accurately describe it to others if you need assistance (especially FREE assistance). We are not mind readers.

What do you mean by "kind of like windows hierarchy"? Are you creating Userforms or using Sheets to be your 'forms'?

Is the mockup you supplied suppose to be in a Userform? If it is supposed to stay in spreadsheet form, what do you want to link it to and how?

Data validation?

Sorry, I'm not speedy. Just call me stupid