Consolidating data from many worksheets

Hi guys,


I'm new to the forum and I specifically joined for this post though I'm pretty sure I'll be going here a lot again now that my job requires a lot of advanced Excel skills. I hope you guys can help me!

So on to my problem. I was assigned the task to shoot out surveys to our clients and have the data consolidated. Basically, it's a matrix where the x-axis reflects time and its counterpart reflects location. I've inserted a capture so that I wont have to explain in detail how it looks like:


cog.jpg


I have hundreds of these and basically I have to tally the returns per box. ie. one sheet reflects 3 on San Lorenzo-12-12:59 intersection. I have to SUM all the returns PER intersection of ALL the sheets that I have. Perhaps it was stupid on my part not to have thought of the format to accommodate an easy way of tallying the data(lesson learned), nonetheless my problem is that I don't know how to do this. I've explored pivot charts, consolidating the data manually, etc etc but to no avail. Hope you guys can advise me of the best/easiest way to do this!


Cheers and many thanks in advance!

Hello and welcome to the forum.

When you tried consolidating the data manually, what challenged you faced?
Can you upload your work in progress workbook here ?


Regards,
DILIPandey
<click on below * if this helps>

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.