Refine Values In Dependent/Linked Drop-Downs

to make the user experience better by inserting the " Stock Search" sheet to speed up the process. The spreadsheet attached is a simplified version of the current version, where it would normally have many many more sites, areas and models of cars. The existing process means the user has to trawl through the sheet where they are only interested in what sites in their area has stock. I can not change the format of the "Red" and "Yellow" sheets so hoping to insert another sheet to do the work.

I am hoping to have on the "Stock Search" sheet a few drop down boxes.

The user will select

1. Area
2. Type of Colour (the type of colour selected should link with the sheet name in effect, so only stock within the "Red" sheet will be shown if the "Red" colour is selected from the drop down box)
3. Model of Car

This will then give the resulting Store/Stores with stock (value 1 or above) with those conditions met which is showing in the relevant sheet

So as per the attached sheet, if a user selected Area "South West", "Red", "Renault Megane"

then SO10 Clifton 1 and SO15 Yeovil 3 would be shown in a list.