I receive a large spreadsheet that is a combination of reports from multiple
distributors. Each distributor lists customers with slightly different
names, and then their total sales to that customer.

Example customer names:

Danaher, Danaher Industrial, Danaher Chemical, Danaher industries, etc. I'd
like to automatically sum the sales to all of the *Danaher*.

How do I go about?