Consolodating Data from Multiple Worksheets

[sidharth52]

I have a excel workbook containing around 500 sheets. Each sheet contains some financial data about a particular firm.
I want to consolidate data in the following manner for a particular ratio say PE.
It should look particularly like this FOR SAY Adjusted PE

Firm Mar-13 Mar-12 Mar-11 Mar-10 Dec-08
3M India Ltd 81.06 63.91 38.21 27 18.16
...
....
....

The firm name can be found in cell B2.
And the data can be found in cells C4:G4.

I'm an amateur so please provide a detailed how-to for this.

Thanks

 

[L. Howard]

Hi sidharth52,

Your screen shot shows three sheets. How about posting a link to that workbook which I assume to be an example of your mega workbook.

I use Drop Box but there are others.

It is easier to work with usable data rather than from a screen shot.

You don't say where the data for 3M India Ltd is supposed to go, what sheet and where on that sheet.

Regards,
Howard

 

[L. Howard]

Are you still interested in a possible solution?


Howard