How to reference C5, D5, E5 from sheet2 in A1, A2, A3 of sheet1?

[Mark]

How can I copy consecutive columns with formulas from sheet2 to a row in
sheet1?

 

[Max]

One way ..

In Sheet1,

Put in A1:
=INDEX(Sheet2!$C$5:$IV$5,ROW())
Copy down to A3