How to insert a data validation dropdown list menu from another worksheet on Excel

1) On the worksheet that contains the list, create a range name.
2) On the worksheet where you want to use the list, click Insert > Name > Define.
3) Make sure you can see the range name specified on the other worksheet. Click OK.
4) Select the cells or the entire column or row where you want to insert the dropdown menu, then click Data > Validation.
5) In the Allow box, select List.
6) In the Source box, type =ListName (range name). Click OK.

Source