I would like to be able to add a footer to multiple worksheets in a workbook. When I highlight all the tabs and add a footer, the header in all of them change to the first one. How can I just make the one change on all worksheets without the header changing?