I have already setup dependent lists for example if in the "Region" drop down in Cell E4 if you select "EMEA" then all EMEA countries will display in the drop down for cell E5.
This is what the data looks like
(Cell D3) Company
(Cell E3) ABC
(Cell D4) Region
(Cell E4) EMEA...