I want to have a single cell in my MS Excel 2003 spreadsheet that
combines both plain text with the value from a Named cell.

It would be something like:

The text I am looking for is (=VS1).

VS1 would be defined on another tab in my workbook as some value like
Merry Christmas.

The results in my cell would display:

The test I am looking for is Merry Christmas.