Month wise datas change if the common factor change

I have a file with 2 worksheets.Sheet 1 is the summary and another sheet is data sheet.On sheet 1,I want to change my plant from HHHD to HHHG or HHHU,the datas should be change according to plant wise and month wise.Is it possible?

Please refer the attached file for more clarification.

Regards

Pradeep Kumar Gupta

There are several possible ways of attempting this, depending on your true data layout, but try:

=INDEX('2010-2011'!$C6:$K6,1,3*COLUMNS($A:A)+MATCH(Sheet1!C$3,'2010-2011'!$C$5:$E$5,0)-3)

or this, slower, but more general solution:
=SUMPRODUCT(--(C$2='2010-2011'!$C$4:$K$4),--(Sheet1!C$3='2010-2011'!$C$5:$K$5),'2010-2011'!$C6:$K6)