Set up a Consolidation Account Tree

Create a structure using Headings

Toggle on Summary only for each Heading

Then map the individual accounts to the headings for each Organisation

Reports will then run summing the Headings for the three organisations on a single line