Compiling Validation List With No Duplicates

I have a sheet called "Usage Data" and in that sheet Column A is called "DTL_LOC" (Warehouse #)

I need to pull all data from this column and create a list with no duplicates. Data is both Text & Numeric.

I need to use this information in a Validation List on my "Inventory" sheet in C1

The list is currently located in L3:L102 on the "Inventory" sheet. However this list may increase or decrease as the company grows.

Thank you,

Mike