Hi! I have a workbook with multiple sheets using the same header. I'm trying
to insert the contents of a named cell from the first worksheet into the
header that is used for all of the other worksheets. The first sheet is
called Data Entry. The named cell is Target. The header would look like this:
Company name: <Target>

Your help would be greatly appreciated!