A 'Key' in Excel?

[mantecasam]

Good morning all,

I am working on a multi page project, that one of the pages has data that we pull from an online database. The Employee file reads: Jones, Jerry. The data from the online database is: Jones,Jerry-12345678. Another page has the information in two columns: Jones | Jerry

Is there a way, or a key that can be used to match: JONES,JERRY-12235987 ; Jones | Jerry ; Jones, Jerry ; Jones, Jerremy (Jerry) as one person and filter it to read: Jones, Jerry in my end result with out manually changing all the data by hand?

In the attached file, the 'Reports' tab pulls the name from the Officer tab, but data may be different in the various other tabs. The data the Reports page is looking for, ideally would be exactly as it is in the Officer Tab, but unfortunately, we use various systems, that does not have a 'uniform naming' system.

Any suggestions would be greatly appreciated.

I would be willing to try this in Access, but honestly, I have no idea how to link the data...