Is it possible to change header for all sheets without changing the page orientation?

[inese_green]

Hello! Hopefully you can help me to solve my problem!
I have excel workbook with multiple sheets. And the sheet orientation are both - vertical and horizontal. I have faced the problem, changing the header information for all sheets, automatically all sheets change the orientation to Vertical! Every time I need to change back the page landscape page orientation. Maybe somebody had the same issue and can help me to solve it! How to change header for all sheets without changing the page orientation? Can we have a specific cell to appear as a headers instead of changing every time to make new workbook? And is it possible to put formula in header?
I uploaded the image, step by step, how I change the header.

Thank you and have a nice day!