I'm sure there is a way of doing this but I haven't been able to figure it
out ...

I want to include some variable text in a sheet header - the text being
contained in a cell within the same workbook. I can find ways of including
the sheet name or file name in the header but not a specific cell's
contents.

Can somebody point me in the right direction?

Thanks.