Is there a VBA code that could convert initials to full names

[Tara_A_Data]

Dear Mr Excel,
I have a huge spreadsheet that downloads from our data system with staff initials. I need to add all the actual names onto this (firstname, surname), is there a VBA code that I could use to assist with ease?
I would be very grateful if someone could assist me with this. Please let me know?
@Tara_A_Data

The Initials all pull from the database like this ($CAL) or $MSH - these are what I would like to convert to full names using a listing of sorts but ideally via a VBA code.

Wed

SK4L1/Lr ($CAL) ($BG) $MSH ($SHS) ($AJW) (#HALL)

SK4L1/Wi ($CAL) ($BG) $MSH ($SHS) ($AJW) (#MP3)

SK4L1/En ($CAL) ($BG) $MSH ($SHS) ($AJW) (#MP3)

SK4L1/Bc ($CAL) ($BG) $ACL ($SHS) ($AJW) (#MP3)

SK4L1/Ck ($CAL) $ME ($BG) ($SHS) ($KTL) ($AJW) (#01)

SK4L1/Ck ($CAL) $ME ($BG) ($SHS) ($KTL) ($AJW) (#01)

Pastoral

Wed

PreVc1/Hc ($EB) ($JEM) $ES ($LWS) (#GRDN);PreVc1/Bm $JPH (#GRG);PreVc1/Cb $ME ($KTL) (#01)

PreVc1/Hc ($EB) ($JEM) $ES ($LWS) (#GRDN);PreVc1/Bm $JPH (#GRG);PreVc1/Cb $ME ($KTL) (#01)

PreVc1/Cl ($CSW) ($JEM) (#OFF);PreVc1/Tt $JM (#13)

PreVc1/Cl ($CSW) ($JEM) (#OFF);PreVc1/Tt $JM (#13)

PreVc1/Cl ($CSW) ($JEM) (#OFF);PreVc1/Tt $JM (#13)

PreVc1/Cl ($CSW) ($JEM) (#OFF);PreVc1/Tt $JM (#13)

 

[Cubist]

Do you have a list of full names?
Please show the expected result for your sample data.