Is it possible to keep the header & footer in Portrait format whilst the page
itself prints as landscape? I want to include Excel Schedules (detailed
excel tables) in a bound report with a Word document and try and keep headers
& footers consistent.

Adobe offers a facility with PDF but it is cumbersome as each Appendix page
needs different title that I generally take from the worksheet tab name.

Thanks