Import/Sum/Multiple excel files

[Pretty Tree]

First off, Thanks for anyones help. My coding skills are very limited so I really appreciate it. I have been reading through the posts and cant find something specfic to what I need. First I send out excel files to about 50 users a week to be filled out and score certain categories.

The basic format is as follows
A-----------------B-------C--------D
1----------------------------------------
2---------------------------------------
3--------------------------WK1----Wk2
4-------------------------------------
5-catogories-------------------------
6-Cat 1--------------------3--------10
7-Cat 2--------------------4---------5
8-Cat 3--------------------5---------4
9-Cat 4--------------------6---------9
10-Cat 5-------------------7---------10

The Scores can range from 1-10 and I need to import all of the sheets and average all of the scores for each category and week into a master sheet with the same format.

Again thanks in advance for any help!

[Pretty Tree]

Thanks again for any help