I have a multi-page spreadsheet with repeated rows at the top. In one
of the repeated cells (or the header), I would like to have a formula
generate an output.

Example:
1 Page Title | North01.05
2 Room | Row | Cabinet | More Data
3 North | 01 | 05 | Blah
--------------------------
Page Title | South02.08
Room | Row | Cabinet | More Data
4 South | 02 | 08 | Blah
--------------------------

I am able to get the concatenation to work fine for the first sheet
(=[A3] & [B3] & "." & [C3]), but it just repeats that value
(North01.05) on each page. How can I make Excel reevaluate this
formula for each page (i.e. =[A4] & [B4] & "." & [C4] for page 2)?