external database file into excel formula
 

Hi,
I have multiple excel files that usees range name and data validation,
is there a way to link Sumif or Lookup with external database file and
data validation. Most likeli I should say, can I import from database file
into formula