combine three reports

Hi the attached has 4 tabs with different tables.

Id like to be able to create the outcome tab in access by combining the tables on the first three tabs. Note the tables on the first three tabs don't necessarily have the same account numbers.

How would I do this?

Any help much appreciatedaccess.xlsx

you would export the 4 queries in a macro (or vb code) similar to

vFile = "C:\folder\file.xlsx"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qsQry1", vFile, True, "Capital"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qsQry2", vFile, True, "Income"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qsQry3", vFile, True, "Investment"