How to change a second drop down menu selection from the selection made in dropdown menu 1

Hi

I am new to excel and have played around with a database of parts information looking for a combination of values made in three drop down menu's.... This works and did what i required.....but now i need to up the game and change it slightly to work with other variables... This now goes beyond my current knowledge level...

I would like to choose a item in my first drop down menu that generates the contents of the second drop-down menu.. After making the second selection i need to generate the third drop down menu..... After this i need three pieces of information to be displayed in three separate columns... If someone can point me in the right direction, then perhaps i can go one stage further, and make the first drop down selection also change the title of the second drop down menu and again for the third!!...

Anyway, so far i have used the INDEX - MATCH functions to search three criteria and display one cell of information....

Thanks for any information or guidance.

Anybody have the time to help?



Here is the file.. I just need to know how to change the second drop down menu named position, with a limited output dependent of the selection made in the first dropdown menu.. example if a AMCU was selected there would be position 1-3, if it was an EADB, it would be 1-7. and then the info in columns F,G and H would be displayed if the required fields..