We've had success using named ranges for this.

Name the range that contains your list  on the secondary worksheet
(you may need to tweak your range if the length of the list changes
from your DB).

Set your validation  type to List and in Source field, simply type
='list name'