Cell referncing help

[richardlit]

Hi

Each row on sheet2 has data relating to a customer.

In sheet1 I am having to get this data in cells over multiple rows. e.g.

=Sheet2!A1 =Sheet2!B1 =Sheet2!C1 =Sheet2!D1
=Sheet2!E1 =Sheet2!F1 =Sheet2!G1 =Sheet2!H1

When I copy this formula down I want row 3 and 4 to reference row 2 from sheet2, row 5 and 6 to refernece row 3 from sheet2 etc etc

=Sheet2!A1 =Sheet2!B1 =Sheet2!C1 =Sheet2!D1
=Sheet2!E1 =Sheet2!F1 =Sheet2!G1 =Sheet2!H1
=Sheet2!A2 =Sheet2!B2 =Sheet2!C2 =Sheet2!D2
=Sheet2!E2 =Sheet2!F2 =Sheet2!G2 =Sheet2!H2
=Sheet2!A3 =Sheet2!B3 =Sheet2!C3 =Sheet2!D3
=Sheet2!E3 =Sheet2!F3 =Sheet2!G3 =Sheet2!H3


Is there an easy way to do this?

Thanks
Richard