You may want to create a drop down list in Google Sheets from data that is in your spreadsheet. This data could change from time to time, and the values in the drop down list will change with it.
A drop down with dynamic values can be created in just a few steps. Select the cell(s) that you want the drop down to be in and then go to Data and then Data validation.
Once the Data validation box pops up, choose list from a range. This is where you will select the range that holds the values that you want for the drop down.
Insert your cursor in the box to the right of List from a range and then highlight the range of cells that contain the values that you need.
To select cells that are not next to each other, just type the cells or cell ranges in separated by commas.
When you get back to the Data validation window, the range that you selected will be pre-filled in the Cell range box of the Data validation pop-up window.
Click Save and your drop down box with dynamic values is complete.