Cod Stats Ranked.png

I'm trying to make a spreadsheet that will track the averages and lifetime performance of my team. The top chart is per match. I would like a marco/VBA that can take the data from the top chart and distribute it to the below charts. At the end of every match, I will be entering new information into the top chart. I would need this macro/VBA to sort it to the correct table by the map and then further by player. In the tables for the specific map, I would like it to average for each player all the different matches we have played (average kills, deaths, hill time). The K/D in those tables can be calculated separately (I can do). On top of this, I would also like to keep lifetime stats with disregarding the map. That is the bottom table. Here I would like it to add the new kills, deaths, and hill time in with all the matches I have previously entered separated by each player. Once again I can do the K/D here. Not even sure if this is possible but figured I would send it out and see what happens.