I have a spreadsheet (Work Flow) with data going horizontal from columns F to Q. I am trying to copy this data to a separate spreadsheet (monthly income). This data needs to go vertically. The problem I am having is trying to copy this down vertically. I need the column to change not the cell number. I am trying to reference just the cell. No additional formula. Below is an example of how I need it to transfer. I would like to be able to drag or copy and paste this information and not have to actually reference every cell on the monthly income spreadsheet.

Work Flow Monthly Income
F3 H2
F5 H3
F7 H4
F9 H6
F11 H7

Work Flow Monthly Income
G3 H10
G5 H11
G7 H12
G9 H14
G11 H15

When I copy or drag down the formula to the new columns on Monthly Income it changes the cell number not the column.

Is there a way to get the column to change and not the cell number?

Thank you in advance.