Merge several spreadsheets together to create a master report.

I need several spreadsheets merged to create a master report. Merging will need to be keyed off of the "Name" column all rows need to add up properly / show correct percentage. Files are attached.