Automating the merge process might merge some of the wrong records.
You could use a semi-automated process.
Create a master list of the correct or 'approved' account names (you will be able to use this in the future as DerbyDad03 says, for data entry validation).
Have the names in a column somewhere on the same worksheet, say column F.
Now insert a new column to the right of the original Account names. This new column will be column B.
Select all the cells in this column alongside the existing account names in column A.
Right-click this selection and from the Data menu select Validation...
In the validation dialog box, in the Settings tab, select List in the 'Allow:' drop-down
In the 'Source:' box enter the range of cells containing your 'approved' names.
Now go down your list of account names and in the new column B, use the drop-down in each cell to select the 'approved' name for the name used in column A.
Once this is done it will be easy to combine all the data for each account.
Next to your list of approved names (if the list starts in cell F2), enter this formula in cell G2
where $B$2:$B$100 is the range of cells with the selected approved names and $C$2:$C$100 is the column with the service requests - adjust the ranges as appropriate.
Drag the formula down to the bottom of your list of approved names. You will now have the totals for each name.