Hi @condale777 ,
Believe that the best option in this case is to have a table with the ID of each company, and add that field on your tables then you can make a relationship by the ID instead of the name or creating virtual relationships.
If you compile all the names into a excel file, a sharepoint list, a table somewhere then you can do the merge by name and get that data into each table directly, only maintaning a single spot for the renames.
Miguel Félix Did I answer your question? Mark my post as a solution!
Proud to be a Super User!Check out my blog: Power BI em Português