I have a 12 sheet workbook. I want to create headers with the format

xxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxx &Tab

so when it prints - the actual tab name prints. I have tried using the
Repeat page setup, but it puts the name of the tab I copied from as &Tab.

How is I create one header and have it repeat on each sheet with the correct
TAB name in it...

Please help