(Multi-line headers can be a problem if you are using excel as a database, using Autofilter etc. Consider having a zero height blank row above your last title row.)
Put the macro recorder on.
Header Row:
1.Window,FreezePanes
2.File,PageSetUp,Sheet Rows to repeat at top
Expand, collapse rows/columns:
Data, Group and Outline
Post the recorded code back if you need help manipulating it
Gavin