Combine similar name data

I have information in Reports on several branches of the same company. ie: Coy 1 , Coy 2 , Coy 3

I simply wish to do a lookup for any "Company Name" that begins with "Coy" and prepare an amalgamated sales list.