I cant work out how to create a drop down menu that relates to another drop down menu

Can anyone help me link all the sheets please? I have colour coded the boxes so you can see what needs to link to what, I can only have one option in the prime area or specific area not one in each. I haven't added all the development files along the bottom because it would take me forever. I need the empty boxes next to prime area, Specific area, aspect of area, stage and link to development to be drop down menu's

Can anyone advise me please?