Trying to create a master schedule in Excel using VB scripts and PowerQuery

I have embedded a VB script in the company's MS Project .mpp files to export themselves to XLS files to a specific folder on a network drive. Then, I have PowerQuery in Excel combine all of those XLS files in that folder into one large table.

I'd like to take that large table and turn it into a multi-project gantt or swimlane chart, some way to visualize how many tasks/hours/operations will be necessary in a given time period. Googling and asking LLMs for guidance point me to a stacked bar chart, but I'm hoping some experts may have better advice.

Is it folly to try? Is there an easy solution? Should I be looking at PowerBI instead of Excel to turn the several XLS files of .mpp exports into one large overlapping master schedule?