Combining Excel Files

[amit.narayan.rai]

Hi,

I have a very specific task at my Hand..
I have excel files which record purchase made for products daily at Prevailing market rates.

I need to combine the sheets together.

Each Excel file corresponds to the purchase made in a Particular Month and each tab within corresponds to the supplier who has supplied the product for that month.

Also, First Row is Product Name and Next 2 are Total Cost and Rate on that day.

I have added a sample file at following location.
https://docs.google.com/spreadsheet/ccc?key=0Ah1AoeMyTuuGdEtsQXZaNzRLMnhENkIya1F2OWFjSkE&usp=sharing

The final Output I need in following format :

Date of Purchase,Supplier Name, Product Name, Cost, Rate

Please help me...I am really stuck due to very specific design of the excel files..

Thanks
Amit Narayan