Use Indirect function for both sheet and cell address

[MandeepBajimaya]

I want to use indirect function for consolidation purpose.
I would like to get cell E6 to E27 of different sheets as per heading like BOPL, EAPL and so on.
There are two variables. one is sheet name and other is cell address
What can be the best way to do this?

 

[etaf]

what cell is E6 to E27 in
not sure form the image - maybe B

indirect(C$3&"!"&$B6)

Book1
	A	B	C	D
1
2
3			A	B
4
5
6		E6	Sheet A E6	Sheet B E6
7		E7	Sheet A E7	Sheet B E7
8		E8	Sheet A E8	Sheet B E8
9
Sheet1

Cell Formulas
Range	Formula
C6:D8	C6	=INDIRECT(C$3&"!"&$B6)

Book1
	A	B	C	D	E
1
2
3
4
5
6					Sheet A E6
7					Sheet A E7
8					Sheet A E8
9
10
11
a

Book1
	A	B	C	D	E	F
1
2
3
4
5
6					Sheet B E6
7					Sheet B E7
8					Sheet B E8
9
10
11
b