Creating dynamic reference from another workbook

[dpaton05]

I want a drop down list in one workbook that references a dynamic list in another workbook ie it may have entries added to it so I can't hard code the reference?

If I select data validation for a cell, I set it to allow a list but what do I put in the source for the list to be from another workbook and for it to be dynamic.
This list will start in A2 and go down. There is nothing under it.

Thanks

 

[mikerickson]

My guess is that if you move the client_list file, it will have to be when both the workbooks are open.

As to VBA, I don't think that that will let you move files about. How is the VBA code to know the new location of client_file?