Harvest Data & Drop into another Spreadsheet?

[aidan80]

I receive (example attached) a number of excel sheets via email every week containing orders for supplies. What I’d like to do is find a way in excel if possible to harvest the data from these excel sheets and drop it into another spreadsheet, a master sheet that has all of the supplies and all of the “areas” e.g. areas 1 – 35 in it. At present this is done by hand with someone looking up area 1 and going through item by item and moving the totals into another spreadsheet. As you might imagine this takes a lot of time.

Any assistance would be appreciated.

[Charles]

aidan80,

Cold you post an example of the expected data in the worksheet.