Try this

You have created drop down with machine names for cell A3.
Assumed source for the drop down list in Cell F1:F10
as Machine 1,Machine 2,Machine 3,Machine 4....................
e.g.,
Col F Col G
Machine 1 2
Machine 2 3
Machine 3 4
..
..
..
..
2,3,4....... is the sheet number as you said if you choose Machine 1
you
need Sheet2 B5 as your answer, if u choose Machine 2, you need sheet 3
B5
as your answer......... for that reason I have used col G.

know your formula
=IF(A3<"",INDIRECT("sheet"&LOOKUP(A3,F1:F10,G1:G1 0)&"!B5"),"")




On Jan 24, 4:59*pm, Junaid wrote:
I have one file with 11 sheets. All sheets have same column & rows headers.
1st sheet is summary and the other 10 sheets 10 machines. every machine has
its own saparate characteristics. in one column of the summary sheet i
entered all the machine names and in Cell A3 is validated with these names.
My file is just like below

* * * * A * * * * * * * * B * * * * C * * * * *D * * * * E * * * * * F
........ * * * * M
1
2
3 Machine name (this is drop down validated cell with machine names)
4 Descriptions * * * Jan * * *Feb * * Mar * * April * * *Mar ...... * * * *Dec
5 Total time
6 Shut down
7 Capacity
8 Load time

In B5 i entered the formula =if(A3=Machine 1, Sheet 2! B5, if(A3=Machine 2,
Sheet 3! B5, if(A3=Machine 3, Sheet 4! B5, .....) and then i drag it up to
december and to the last required row but it works up to machine 8 after that
its not work. and its work fine when i select the machine from drop down list
in A3 the data appear from that sheet. please tell me if there is any other
formula. thanks