Combining sheets and data

Hi all,
I was after a little help. I have 11 seperate sheets with differ data in them (score cards with names and scored) i want to combine all data from the 11 seperate excel files into one and if the same name is detected the scores are added. It is a gun club shooting results and i want to find the person who shot the most targets across the year. if it could also sort in grades too it would be best.
i have attached a basic sample

Regards
Anthony Maddick

Sample sheet added into the manage attachment section

Hi,

Instead of 11 files, can you not update all of them into one file and use a Pivot Table to summarize?

here's some tutorials: https://www.ablebits.com/office-addi...-merge-sheets/

Thanks for the input everyone. if i copy and paste all the information into one sheet it would need to find the duplicate names and add the scores together

Yes, it can be easily summarized with the help of a Pivot Table. PivotTables are highly flexible and can be quickly adjusted depending on how you need your result to be displayed.