Macro in Excel

Is there a way to program a macro which sources values from seperate excel files (stored in different locations) without opening the seperate excel files ? I find by opening the various source excel files, my program is considerably slowed down.