Linking filtered data

Hi everyone,

i'm fighting with a file and don't have any clue about how to solve this problem.
I have a huge database with 4 parameter columns and then many values for each line.

In the example file attached with dummy data, i would like to include a dropdown list that, based on the sequential selection, automatically exclude all the others.
Example: first list ferrari, 2nd list automatically excludes all models not ferrari, 3rd includes only engines for the model selected in the 2nd filter.

Is there a way to create these filters with big data without doing it manually?

Thank you,

AlbertoCAR FILE.xlsx

Hi Oeldere,

thank you for your prompt reply.
I totally understand your process.
But probably i didn't express myself correctly.

If i have to work on a different sheet and use 3 dropdown lists to find data.
How can i create those 3 dopdown lists with the criteria mentioned above?

thank you in advance.