Report Suit in Worksapce

You can refer to this documentation for 2 possible solutions: https://experienceleague.adobe.com/docs/analytics/admin/admin-tools/manage-report-suites/rollup-report-suite.html?lang=en

Note that in both cases, the reported data will only be from the time of implementation onwards. Historical data is not included at all. I don't think that even Client Care can import historical data either.

If you need a consolidated report of key metrics and don't care about double-counting the same user in different report suites, and if you have permission to use Report Builder, then you can consider using Excel with the Report Builder add-on to import the relevant data from your 10 report suites and combine them manually within Excel.

If you don't have Custom Journey Analytics, you will need to track all sites in either a completely new "global suite" (recommended), or choose one of the existing suites to make your global suite, rolling the other 9 into that one.

You need to be sure that ALL your sites are using the same tracking profile (within reason.. there can be differences where say eVar5 only applies to one or 2 of the sites, if not all sites have that function)... but for each value, all sites will need to pass consistently formatted data into the same dimensions, trigger events the same way, etc.... then you can use a dimension (something like standard "server" or a custom prop/eVar to distinguish the site), and create Segments to get traffic for Site A, and Site B, etc... then use Virtual Report Suites to pull the sites individually...

Adobe does have a "rollup suite" feature, but I don't know if they still do that... I know they definitely don't recommend it any longer... as that feature was very bare bones, it would just give you rolled up key metrics like Page Views, Visits and Unique Visitors (but it didn't even deduplicate the Visits / UVs).

The global suite / virtual suite setup is the recommended approach from Adobe.