Hi,

I am trying to look up values from the same fixed range (c50:E200) in 45
sheets and extract the values onto one sheet (same workbook) 3 columns at a
time (ie first sheet B-D, second sheet E-G etc). I can't work out how to put
the sheet name (or a reference to the sheet number) in a formula in the
destination sheet - is it possible or do I have to use a macro? I can write
the code for a macro, but as it is statistical process control limits which
are added to each month, it means rerunning the macro every time

Any help much appreciated!

Paul