Choose data from different sheets using one input cell?

Aloha,

My case:
I have A woorkbook with sheetnames Total,a,b,c and dd
Sheet a,b,c,d have a number value in the C1 cell.
Sheet named a have 1 as value in C1
Sheet named b have 2 as value in C1
Sheet named c have 3 as value in C1
Sheet named d have 4 as value in C1

My question:
On the Total sheet I would like to have a cell e.g A1 and when I type the name of the sheet (a,b,c or d) in that cell and then the numbers from that sheet will show in the cell C1.
If I type b in A1 on the total sheet then all the number from the sheet "b" will be showned in the C1 on the Total sheet column. In this case 2, if I put C in the A1 cell the it will result in 3 in C1.

After posting I found another post with a similar problem with better explination:
http://www.excelforum.com/showthread.php?t=587388

Originally Posted by Loranga

Aloha,

My case:
I have A woorkbook with sheetnames Total,a,b,c and dd
Sheet a,b,c,d have a number value in the C1 cell.
Sheet named a have 1 as value in C1
Sheet named b have 2 as value in C1
Sheet named c have 3 as value in C1
Sheet named d have 4 as value in C1

My question:
On the Total sheet I would like to have a cell e.g A1 and when I type the name of the sheet (a,b,c or d) in that cell and then the numbers from that sheet will show in the cell C1.
If I type b in A1 on the total sheet then all the number from the sheet "b" will be showned in the C1 on the Total sheet column. In this case 2, if I put C in the A1 cell the it will result in 3 in C1.

After posting I found another post with a similar problem with better explination:
http://www.excelforum.com/showthread.php?t=587388

Hi Loranga

look at the attached file
there may be the solution you want.