Take a look at Debra Dalgleish's notes:
http://contextures.com/xlDataVal05.html

JackR wrote:

I have a drop down list in one workbook and want to have it look up a dynamic
named range in another workbook, can this be done or does the list have to be
in the same workbook?

--

Dave Peterson