OTM Report extract as multiple tabs of a single Excel Workbook

We have a requirement to generate an automated In-Transit Report using OTM for supplier ASNs. Since different suppliers have different in-transit mapping, we have created different reports (OTBI report template and data model) for different supplier groups. Currently these are scheduled to be sent to Logistics team as separate emails daily. We want to see if it is possible to create a consolidated excel workbook where each tab of the workbook and extract the data from a different data model.