consolidating data from 3 sheet

[Sathisc]

Hi,

I have a spreadsheet where my team updates data everyday. i need to consolidate like a pivot for the entire spreadsheet.

as the data is spread in 3 different sheets i am not able to pull up records.

i have attached a sample spreadsheet.

I am currently using Excel 2003

Kindly help

Regards,
Sathish

 

[Sathisc]

Sorry

I couldnt attach the file