For the header, just use concatenation.
="Title you want "&B4
or
="Title "&B4&" rest of title"
or
=B4&" Title you want"

You could create a template sheet that has your headers and no data, then
whenever you need to make a new sheet, you just copy the template sheet.

- KC
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Hershmab" wrote:

I have a workbook with 12-30 worksheets that are in the same format. I want
to create identical headers for all of them, distinguished only by including
the value of, say, cell B4 as part of the header text.
I have two questions:
(1) How do I get a variable cell-value into any header?
(2) I know how to give any new worksheet the same header as an existing
worksheet, but is there any way of creating a default header that will
automatically attach itself to newly-created worksheets?