Combine multiple tables into one pivot

You can merge the individual tables into one and then create a pivot table off the result using Power Query.

I'll give this a try, thank you!