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.

Why dont you attach a sample file?

So all the tabs in this file should be consolidated into the "Team Merge" tab?

Usually if the data has already been consolidated and then there are changes to your data, its better to run the macro again. This is the ideal way in such a scenario.

Try this code

Please Login or Register  to view this content.

- if you have made any updates to the other sheets, rerun this macro as it will clear the contents of the Team Merge sheet and re-populate the data.

Am glad it worked.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save