Merge seven (7) spreadsheets together to create one master spreadsheet.

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