Help with SUM cell

[hailstorm]

Hello there

I'm doing something manually but it's taking forever to finish so i would like some help to make it faster. I'm copying cells from sheet2 to sheet1 using the equal sign "=sheet2!A1" in this order:

Column A - Column B - Column C - Column D
=a1 - =a2 - =a3 - =a4
=a5 - =a6 - =a7 - =a8
=a9 - =a10 - =a11 - =a12

I'm still half way to go, so any help is ok! Thanks

 

[Michael M]

Highlight the range of cells to be copied>>Copy>>Select the first cell on the new sheet >> Paste Special>>ALL

 

[footoo]

A1 : =OFFSET(Sheet2!$A$1,(ROW()-1)*4,0)
B1 : =OFFSET(Sheet2!$A$2,(ROW()-1)*4,0)
C1 : =OFFSET(Sheet2!$A$3,(ROW()-1)*4,0)
D1 : =OFFSET(Sheet2!$A$4,(ROW()-1)*4,0)

Drag down.