Need Help With Copying Relative Formula

*EDIT - SOLVED*

Hello and thanks in advance to anyone who can point me in the right direction.
I am running Excel 2003 on a Windows 2000 machine.


I have 2 sheets in one workbook.
sheet 1 is data input
sheet 2 is summary

I want to put this into summary

......A...........................B..........................C

1...='data input'B1........='data input'B2......='data input'B3

2....='data input'E1.......='data input'E2.......='data input'E3

I have about 100 rows each of about 10 columns that I wish to do this with.
I know I can do it the long way by hand but there must ba a shortcut I can use.

I have tried coppying and pasting etc but I then get b1,b2,b3 going DOWN which I do not want.
Each row of summary needs to increment the reference to 'data input' by 3 columns ie B,E,H,K

Can this be done? How should I begin?





SOLUTION - in case anyone else comes across this
=OFFSET(Sheet1!$B$1,COLUMNS($A$1:A1)-1,ROW(1:1)*3-3)