I have 50 sheets called run1 ... run50
In G1 of each sheat I have a number (number of rows G4:Gn, in that sheet)
I want to bring the valuse of G1 from all 50 sheets to another sheet
(summary Shheet).
Is it possible to do it by "indirect" command to copy the (run3!G$1$)
reference cell? I couldn't succeed.

--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan