copying cells down

The problem is i have a sheet with names (example J2=User1, P2=User2).
i want to copy the data from one sheet to another but on the new sheet i need to copy down instead of accross (example B18=(sheet1.J2=User1), B33=(sheet1.P2=User2)).

The idea is i need the letter or column to change not the number or row. An example of this would be copying cells down and getting =B2, =C2, =D2 instead of =B2, =B3, =B4 .