Update several worksheets in a workbook

[smazza]

I want to have one master page in a workbook & have it update multiple pages if I make changes to the master page. How can I do that?

My purpose is that I use the page over & over in separate worksheets but hide different columns to print reports for various reasons but I only want to update one page.

 

[Boller]

Instead of multiple sheets, why not just have one sheet and then make use of Custom Views to display a particular sheet format as and when required ?

 

[smazza]

Because I didn't know about that. I'm a basic excel user & can write IF formulas but that's about it. Thank you!