You can populate a dropdown with a list on another sheet by referencing the cells, but the resulting dropdown won’t be dynamic, even when the list is in a table object.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

The Paste Special dialog box opens and displays several pasting options.Click "Validation" followed by "OK." Excel copies the drop-down list to the cells you selected.