I am creating a form and would like to automate it with drop-down lists.

Worksheet 1 has the data entry areas(cells) and the Data is on Worksheet 3
in several lists/ each with a "Name" .

I can have the first column on Worksheet 1 use validation to generate a list
for the product description what I need is for the next column on this sheet
to provide the appropriate drop down list that coincides with the entry in
column 1

Is this Possible?