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