Well, I am not giving you a straight forward answer for your question.
But here is the possible way I would do this:
I would prefer to store the repeated headers in a seperate sheet (e.g. - Header) and point all sheet to the Header Sheet.
Later, at any point of time, to make changes to Header data in all sheets, I can just goto Header sheet and make changes.
This way I can avoid using Macros.