Dropdown list depened on multiple values

I have a workbook with 2 sheets
Sheet 1 has 5 columns (A to E) and 20 dropdown menus (B2:E6)
Any selection in column (B2:B6) will affects the dropdown values in column (C2:C6) but the dropdown values in column C will be depended on the values in column (A2:A6)
The dropdown menus in (D2:D6) is depended on the dropdown menus in column (B2:B6)
The dropdown menus in (E2:E6) is depended on the dropdown menus in column (C2:C6)
I try indirect functions but cannot make it works. To me it looks simple but so complicate when use dropdown menus to fill the selected cells
Please see the file for conditions and goals
Thank you so much for your help.
Thup_98