No need for the plus sign btw

=INDIRECT("'M"&ROW(21:21)&"'!B27")

copied down will get B27 from M21, M22 and so on


Regards,

Peo Sjoblom

"dal0506" wrote:

sheet 1 cell 4a =+'M21'!B1, cell 4b =+'M21'!B27, etc..
Sheet 1 is a report, sheet 2 (M21), 3, 4, etc contain data that needs to
feed the report, how do i copy the formula to the next line and change the
reference to which sheet it pulls from instead of it changing the cell on the
sheet it pulls the data from? Can some one PLEASE HELP!!