Merge several spreadsheets together to create a master report. -- 2

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.