my formula is

=2244!$S9 (2744 is the name of the sheet I'm taking info from)

I'm needing to cut and paste this formula into a cell a few columns down so
it will read.....=2744!$S10

Then further along...-2744$S11 and so on.

I cannont drag the formula has there are other formulas in the columns in
between.

Thanks