Use "Indirect" Function with a variable reference 1

[jpgactmod]

I have several worksheets with matrices that I am trying to reference by using a summary worksheet. For example, I know I can do the following:

=INDIRECT($L$24&"!B10"); where L24 contains the worksheet name and this references Cell B10 for the Worksheet named in Cell L24.

What I am trying to do, however, is copy the cell containing =INDIRECT($L$24&"!B10")using a relative reference for B10. For example, if Cell A1 contains =INDIRECT($L$24&"!B10"), I want to copy A1 to A2 to get =INDIRECT($L$24&"!B11"). But I cannot figure out how to get "Indirect" to let me use B10 as a variable. Thank you for any help. Jim

 

[SkipVought]

use the ROW() plus a constant to get 10, 11, 12 as you copy the formula down...
[tt]
A1: =INDIRECT($L$24&"!B"ROW()+9)
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jpgactmod]

Thanks again Skip. You are a great help!!
Jim