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