If you have access to Adobe Report Builder that would be a straightforward method to construct this report in Excel. You would need to build data blocks on a per report suite basis containing whichever information you needed and then wrap up with a summary spreadsheet view.
Best,
Brian