Let's start with Sh30 ( you already have Sh00, Sh10, and Sh20). In the third
row of any un-used column (say Z) enter:

="Sh"&10*(ROW()-1)&"!L10" and copy down. You will see:

Sh30!L10
Sh40!L10
Sh50!L10
Sh60!L10
Sh70!L10 and so on (WE HAVE INCREMENTED THE SHEET NUMBER not the cell)

If we put this stuff in Z3 on down, then elsewhere enter:

=indirect(Z3,TRUE) and copy down
--
Gary''s Student - gsnu200746


"mikresources" wrote:

There are several sheets in the workbook titled Sh00, Sh10,Sh20...... I am
compiling data form the sheets on to a sheet tilted Sh700. In one of the
columns the formula in the first cell is: =Sh00!$L$10. The data in the
subsequent cells will increment the previous sheet by 10, i.e. =Sh10!$L$10,
=Sh20!$L$10... How can fill the remaining cells without having to manually
chaning each Sheet numbers?
Thank you