I have a workbook with 4 sheets.

Sheet 1 Column A allows users to enter a location name
Sheet 2 Column B automatically creates a dynamic drop-down of the Sheet 1
Column A data

How is this done? I can't find any code, functions, formulas or anything
indicating how it is accomplished.

Thanks in advance.