How to group data together that match account numbers from two different work books

What I am trying to do is make an expense report for 4 months, so I can see how my expenses change over the months, and maybe even have a variance column. I pulled the attached reports from QuickBooks, but qb does not give you just expense reporting.

Anyway, so I want to try and find a slick way to incorporate the expenses from all these individual reports into one report based on the account number, if that makes sense..? Otherwise I would have to do it all manually which will take hours.

Let me try and illustrate.. let's say we are looking at the October workbook, and let's say were looking at account number 5260 Retirement Expense COGS for 352.40. Well, if there was an expense amount in the November workbook for 5260 Retirement Expense COGS, I would want that amount out beside the amount for October so I could compare them. But I want this in all one workbook, not several, so I want to extract the data from one workbook and put it out beside the data from another.

So, the top of my workbooks would look something like ----->>> October November December

Retirement Exp 5260 Blah$$ Blah$$$ Blah$$$

Please help. I know this may be a herculean task, and I would be willing to pay for this if the price offered was right. I need this quickly though. Thank you all for your time and attention.

Alan,

Thank you for your response. I think I followed your instructions exactly, but I get #N/A when I put this in? Please advise.

Many Thanks,

Ryan

Alan,

I do not know what I am doing wrong. I followed your instructions above and I can't seem to get it to work. Can you attach the October workbook with your formula in it so I can see where I am going wrong.

Ryan

Thank you! That worked beautifully.