Drill down data for Validation Cells

Greetings to all,
I am after a bit of help as are most of us here.
Attached is the spreadsheet I am working on, log sheet and example sheet.
As you can see from the example sheet I have location, Equipment type, equipment id and some others.
As you can see on the log sheet, at the moment people select the information from validated cells, but if they select Point Machine from the equipment type list they have to scroll through all the equipment ID’s when they only really need to see 10 equipment ID’s relating to Point Machines. Is there a way to get the validation cells to do this or is there another way.
I am very very new to VBA if this is an alternate way to do this.

Help much appreciated.