All fields in column E of sheet 1 have data validation for drop downs from a list that is specified on Sheet 2. This list is called "Major".

The major list is

1- Color

2- Machine Problem

3- Eyemark, etc...

Now, I have other lists specified on Sheet 2 called "Minor" lists.

If I select "1- Color" from the Major drop-down list in E, I want the adjacent cell in column F to be the corresponding "1- Minor" drop-down list.

If I select "2- Machine Problem" from the Major drop-down list in E, I want the value in F to be a drop down list that corresponds to that value, namely "2-Minor".

In other words, based on the input in E (from a drop-down), I want the value of F to change to various corresponding drop-downs.