make this formula dragable

[beekerdale]

This formula works good for me for referencing another sheet, but I am looking to increase the size of the sheet to the right,
And so-I am wanting this formula to to reference R100, R101, R102, R103, R104 "and so on" as I drag it to the right.
Any suggestions?

=arrayformula((IMPORTRANGE("1mRD1xdG5YWOeYPJXPrc6xvuMgha54sbtiV-5imIdbC4","TimeSheet!r100")))

 

[maabadi]

if this formula is in ColumnA then

=arrayformula((IMPORTRANGE("1mRD1xdG5YWOeYPJXPrc6xvuMgha54sbtiV-5imIdbC4",INDEX(TimeSheet!R100:R120,COLUMNS($A$1:A1),1))))

And then Drag it

 

[beekerdale]

Thanks for the help, hum,, it says "unresolved TimeSheet name"
I think we are getting closer though,

 

[beekerdale]

I have updated the formula to this one below,,
I am working on the formula located in C3, And the reference on the other sheet will be from aj43 and dragged to aj51

=arrayformula((IMPORTRANGE("1mRD1xdG5YWOeYPJXPrc6xvuMgha54sbtiV-5imIdbC4",INDEX(TimeSheet!R43:R51,COLUMNS($C$3:C3),1))))

-this formula says "unresolved TimeSheet name"
Thanks for your thoughts, Dale

 

[maabadi]

What about this:

 =arrayformula((IMPORTRANGE("1mRD1xdG5YWOeYPJXPrc6xvuMgha54sbtiV-5imIdbC4", Address(Choose(Columns($C$3:C3),43,44,45,46,47,48,49,50,51),18,4,TimeSheet))))

 

[maabadi]

Above formula is for R column, For AJ column Change 18 to 36

 =arrayformula((IMPORTRANGE("1mRD1xdG5YWOeYPJXPrc6xvuMgha54sbtiV-5imIdbC4", Address(Choose(Columns($C$3:C3),43,44,45,46,47,48,49,50,51),36,4,TimeSheet))))

 

[beekerdale]

Above formula is for R column, For AJ column Change 18 to 36

 =arrayformula((IMPORTRANGE("1mRD1xdG5YWOeYPJXPrc6xvuMgha54sbtiV-5imIdbC4", Address(Choose(Columns($C$3:C3),43,44,45,46,47,48,49,50,51),36,4,TimeSheet))))

That works Maabadi, Thanks so much! You are the best!

 

[maabadi]

You're Welcome & Thanks for feedback.