Gettting data from other work sheets.

[yasirbintariq]

Hi,

I have 125 work sheets in one workbook and it contains data about companies for 8 years i.e. 2003 to 2010. Sheet 1 which I called "index" contains the Name of companies in one column and their abbreviation (sybmol) in other. All the 123 sheets are named as per these abbreviations. Now if you look at attached sample sheet (1 index and 3 sheets), all I want to do is to insert the cell reference of required data in index sheet so that I can have all the data at one place. For this I have to manually give the sheet name and cell reference at each cell in "index sheet" e.g. =FTML!J6, FTML!L6



I need a formula which can pick the sheet name from the "C" column which contains abbreviations of companies so that when I copied it down it will get required values from all respective sheets.

Thanking you in anticipation.

Yasir

I am unable to find option to attach sample work sheet.

 

[VoG]

Try like this

=INDIRECT("'"&C2&"'!L6")

 

[yasirbintariq]

Thank you brother, your formula worked.

Now the formula is taking the sheet name from the Column C. Can it take the other column reference i.e. "L6" from a row where I can put the required cell and column reference.

 

[VoG]

With L6 in B2 try

=INDIRECT("'"&C2&"'!"&B2)

 

[yasirbintariq]

Thank you very much for you kind and quick response.