1. Select the cell you want to change.
2. Data -> Data Validation -> Settings
3. Field: Allow = List
4. In Source field, enter a value similar to:
This is the range from Sheet2 cells A2 to A5
The result is a dropdown for the value of the cell.