I would like to do something similar, but I'd like the header to
change with each page. For example:

List of Payments by Branch and Officer
Branch Name: (name of branch for first row on page)
Officer Name (name of officer for first row on page)

I have the report page break on each change in officer. The branch
name and Officer Name data is in the spreadsheet I just have the
columns hidden from view.

Thanks