Creating data validation rule to create a drop down from a list of items, by filling in the range, and listing the items in Google Sheets NEW

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.