Hi, can anyone help

Is there anyway I can create a drop down list on a form using data that is
located in another workbook yet not have to open it everytime I want to use
the form.

Maybe there is a function that does the same thing? i.e. gets data from a
column and makes a list so you can click a selection.