Creating a Dynamic Dropdown List in Google SpreadSheets via Script

Using Google's App Script which is a constrained JavaScript within the editor, you can leverage many of spreadsheet features via code which is dynamic