Sumproduct Multiple files

[michaela18]

How can I sumproduct across multiple files? Currently I have it set up to update links to other template files. So my process is pretty lengthy in this way. I would take each file everyday and rename them and then put them in a folder and then my master template file updates the values based on the links to the folder I put the files in. Is there a faster way?

 

[SkipVought]

I'd use MS Query.

faq68-5829

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]