Copy-Paste question

Hi, I have a seemingly easy question, that I'm struggling to word properly for the Google machine.
I want to simply copy-paste my Formula, but instead of automatically spanning rows, have it span columns instead. Let me explain by example... because that doesn't make much sense.

A	B	C	D	E	F	G	H
Users	Result	Data 1	Data 2	Data 3	Data 4	Data 5	Data 6
User 1	=C$3	Foo	Bar	Hello	World	Dim	Sum
User 2	=E$3	Foo	Bar	Hello	World	Dim	Sum
User 3	=G$3	Foo	Bar	Hello	World	Dim	Sum
User 4		Foo	Bar	Hello	World	Dim	Sum
User 5		Foo	Bar	Hello	World	Dim	Sum

Please ignore the lack off "accuracy" in the data and formulas... But I basically want to copy the change in Columns (in column B), down the rows. So the next user would see =I$3:I$8, then =K$3:K$8... so on.

Please forgive if this is ridiculously simple. Couldn't come up with a clever string to google to explain this.

Thanks