entering data as abbreviations and outputting full words

i am making a workbook for my company which includes different phases for jobs. certain worksheets are only for the company to view while the client only sees one worksheet.
i know how to link information between worksheets, but i need to have it appear differently depending on what worksheet it is in.

for example:
if i enter the acronym "SD" on one worksheet, but want it to appear as the full name, "Schematic Design," on another worksheet, how would i go about doing that? thank you in advance.

sincerely,
henry

thanks for your help. couldn't have asked for it any faster or easier!