A couple of questions
1) Do you want each tab to print on a single page, or will the data per tab go onto more than one printed sheet ? data per tab can onto more than one printed sheet but i do not want columns on multiple sheets, columns a-z must print on each sheet lanscape layout.
2) When you say repeat header do you mean repeat the top row onto every printed sheet (if the tab data goes onto more than one sheet), or the "Header" as in View>Header and Footer- repeat rows 1-8 on every printed sheet
3)Does your data on each sheet go further than Column Z - no it does not. the rows of data always vary but the columns are static.