Excel Mac 2011 Merging data

[chickieram63]

Data has been exported from Quickbooks financial reports P&L. I want to merge all months into one worksheet, but the problem I am having is some months there are 51 rows of expenses, and some months may 45 and the same is true in the income section. Therefore, when I move them to the one sheet, the lines don't match up so that I can't y-t-d a row. I have been copying/cutting and pasting and wasting much to much time.

Can you Excel guru's give me a fix for this task and accomplishing it quickly?

Would appreciate any advice.