What would be the best way to get values from multiple excel files into a
separate file to do some SUM's?

Basically I have different Excel files, with multiple Worksheets in each,
that I need to get values from to do some summary formulas. Is it possible
to create formulas that look at other files or do I need to pull the data
from those files into the summary file and then do calculations?