Multidiemntional vlookup and autofill cell

Bonjour, I have a difficult one here (for me at least).

I am trying to fill a series of cell that are dropdownlist themselves and there adjacent cells based on the selection made in an other dropdownlist.

Scenario :
The spreadsheet is used to build spaceship (yeah, I know, but it's an example )

To build a space ship, you need to choose, from a list of components and the number of each components. Not every spaceship needs the same components and not de same number of the chosen components.

Components :
Cockpit
Wing
Cargo
Passenger suit
Engine
Radar
Weapon

I have a list of 15 dropdownlist cells where you can choose the component you want to build the ship and the number of component. You can freely create your ship OR use a pre made ship from a dropdownlist.

The choice you make for your pre-build ship will define what is going to appear in the dropdownlist below along with their numbers.

I know how to work with VLOOKUP and different array, I don't know, though, how to work with a cell that will be a vlookup OR a dropdownlist and I don't know how to work with multiple table since not all table have the same number of items no how many items.

I hope this weird example is clear enough and that you will be able to point me in the right direction.

Thanks,
Regards,

Thanks MarvinP,
I don't get how this could be of any help, not sure I do understand well the "choose" function.

Basic question, can a cell be a dropdownlist OR calculated value at the same time?

In the spreadsheet (SpaceShip.xlsx) you will find, at the top, all the named list I have created.

In cell B10, you can choose a spaceship or not.

In cells B13..B25 there is a dropdown list where you can choose different components and enter their quantity.

If I decide to chose a pre-build ship, in cell B10, I want cells B13 to C25 to automatically fills with value for each type of spaceship (see named list).

This can be VB or pure excel, I don't care, as long as I manage what I want to do.

Again, thanks for you help and, most of all, invaluable expertise.

Bonjour MarvinP,
I thank you very much for your time and expertise, Excel is a beast to master but it is darn powerfull....

Your VBA script is exactly what I was looking for.

Tanks You!