Importing data and update, query?

Hi,

I'm looking to create a "tool" with information coming from two different documents (excel), one with price info etc and one with sales figures etc. These individual documents are going to be updated now and then (and need to stay as seperate documents), and I want the combined "tool" with these documents' info to also be updated. So I've been playing around with MS Excel's query function to import the data. Thought I had it all settled but now when I tried to see if the data would sync by pressing the "refesh all" button, I just get an error (after having changed a figure in one of the original documents to see if it worked).

So basically my question is, why do I get an error? Is this data import function not inteded for what I'm trying to do, is that why I get an error? What should I do?

Thank you,
Emma