How to merge different spreadsheets with no unique identifiers

Hi everyone!

Hope your all well and not too cold

I have a big problem that I have been trying to work out how to do but am just not understanding how to do this.

I have different spreadsheets that contain different lifecycles of a customer, From when they are sold a procut, to going live and then being billed etc. All the different steps are done by different departments and each one uses their own excel spreadsheet. The issue is that the all write the Customer name differently. For example: Spreadsheet A = Customer name is "Orange UK", in Spreadsheet B = Customer name is "UK_Orange" in Spreadsheet C Customer name is "OrangeInc".
This is a problem for the majority of the customer names as there is no standardise way of naming the companies.

How would I even begin the merge this data into one spreadsheet so i can analyse the full lifecycle of the customer?

Is there a way of doing a look up table to show all the different customer names and then link all the spreadsheets to this table and extract all the columns from all the spreadsheets into one file?

I hope someone can help?!!!

This is a problem for the majority of the customer names as there is no standardise way of naming the companies.

How about address and or phone number?

Alf