Dependent Data Validation Combobox from Other Worksheet

Hello everyone,

I have 2 excel files, 1 file for the database, and the other file is the template worksheet.

I want to make the template worksheet autocomplete, just like the sample from Contextures.

Here's the from Contexture:
http://www.contextures.com/excelfiles.html

Look for the text: "DV0032 - Dependent Data Validation Combobox"

The problem is, I don't know how to 'connect' the database in its script.

Can anyone help me to solve this problem? I really appreciate your help. Thanks..