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