Aggregate data from Multiple workbooks

Running into a roadblock here.

Each of my team members fills out a Activity Tracking form each week, which they synch with Box.net, which synchs to my desktop folder. I want to consolidate the data from each of their workbooks into a master spreadsheet - I have created a work book for each person with their own tab. I then used a data source to import in the columns and rows to each respective tab using the MSFT query function.

that works just fine and the data auto refreshes - I am stoked about that!

However, at the end of the quarter, I need to roll up the data into a master - meaning I need to take each workbook and merge them into one primar workbook.

I'm getting errors and running into roadblocks. I am thinking at this point the only way to do this is a macro - I am not an expert on this.

Anybody intereted in looking at the spreadsheet for me? I'd be eternally greatful.