Autofill a row from sheet 1 to a column on sheet 2

[Janet]

I want cells D2, E2, F2, G2, H2, etc on sheet one

to autofill onto columns on sheet 2

="Sheet 1'!D2
="Sheet 1'!E2
etc.

Is this possible?

 

[Sheeloo]

Enter this in A1 of Sheet
=INDIRECT("Sheet1!"&LOOKUP(ROW(),{1,2,3,4,5,6},{"A","B","C","D","E","F"}&COLUMN()))

then copy across and down...

----------------OR-------------------------
If you want beyond F then add to the lookup
or enter numbers in Col A of sheet3 and corresponding letter numbers in Col
B and
use VLOOKUP(Row(),Sheet3!A:B,2,false) instead of Lookup

----------------OR-----------------------------
Use
=INDIRECT("Sheet1!"&CHAR(ROW()+64)&COLUMN())

it will work for 26 columns...