Forsay I have the following text in one cell:

Bold text (such as a word) - normal text (such as the defenition)

I want to use this cell in a formula, so when it is updated on it's sheet,
the sheet that it's link to changes with it, but keeps that formatting.

At this time, when I call it (or link it) Excel removes all formatting. I
don't want to go into each cell and format it myself each time. There are
too many tabs/sheets.

Any suggestions?