I am working on a new project. I have 25 worksheets within the the workbook. Each is named differently. I would like to be able to create a macro which will determine how many pages to be printed for each worksheet, and for every new page within that worksheet, for it to copy from the first page cells A1:E6 (which contains the heading of the tables) and them those headings in cells A1:E6 of the following page, without deleting the information which begins on the new page. Also then insert page numbers on each page.

Also how do I write a macro which will select all worksheets and password protect/unprotect multiple sheets at once. typing in a password for 25 or more individual sheets is a daunting task

Can someone help me please.