I was expecting to offer a bridging solution in excel using VT but they are not offering this so I will have to completely rethink my MTD offering to ...

Even the simplest spreadsheets—budgets, lists, trackers, and the like—can benefit from the powerful features in Excel that ...

in separate Excel files. You can now create a macro that opens each report file, identifies and copies the relevant data, ...