Is there a way to populate a dropdown list from another sheet?

I have a list of employees that change frequently in Sheet 1. I have a dropdown for employee in Sheet 2. Is there any way to populate the dropdown in Sheet 2 with the list from Sheet 1?

Example:

Sheet 2 has a column named Employee.

Sheet 1 has a column setup as a dropdown called Tech.

I want to take all of the names from the Employee column in Sheet 1 and populate the Tech column with the names.


Thanks in advance.

Answers