macro for monthly rolling data

Each month I combine data from two reports into one summary spreadsheet that then calculates the variances between budget to actual. Copying and pasting is driving me nuts, but I can't figure out how to create a macro that will allow me to change the column each month for the new summary report.

For example, in January I need to pull all data from both spreadsheets in column B into my summary worksheet. But then in February, I need all data to pull from column C...etc.

I know you gurus can point me in the right direction! You always do!!

Since you mention cut&paste, are your rows identical in each spreadsheet? And do the reports have the months in columns side-by-side (like columns B thru M)? You might try the CHOOSE function like in this example spreadsheet.