Excel: restrict certain fields for particular person. Make new top of page for each Division.

We have a spreadsheet containing data that will be updated by five managers at various times.  The file has been saved on a common drive for their use.  The data file is divided into five sections.  The head boss will keep tabs on the update.  The program now calculates as expected with totals, subtotals and grandtotals.  The file is protected.  The rows that need to be updated are not protected.  All formulas work properly.

1.  Is their a way where certain cells or columns can be restricted for use by only one person?  I have set these special fields to have a light yellow background to remind the other managers to not input data or delete data in these fields.  Ideally, they would be locked to everyone but this accountant.  I know how to lock the fields.  It's the same way that I have locked formulas and titles.  The unlocked fields include these special fields.

Is there a way that the special user may enter a password "one time" and the program will allow them to update these fields?  Is there a way that the special fields can be locked and unlocked by password?

2.  Is there a way to tell the computer to automatically go to a new top of page when the Division changes.  This is the way that reports can be made for each of the divisions.  One of more pages will be printed for each Division and show the totals for that Division.

Thanks for any assistance you can give.

WS