I am a teacher that has to keep track of 150 student ledgers. Is there a way
to get Excel to do the following? (2007):

1) I cannot seem to make all the headers/footers the same from worksheet to
worksheet in the same book. Due to turnover (about 30+ students a year), it
is not a task wirth undertaking to "reheader" every 150 ledgers.
2) Find worksheets once I label them with student's names (using the "Find"
search). Trying to scroll with the little arrows is not easy with that many
worksheets.

If there is a different MS program that will acomplish this better, please
let me know. There are programs made for this, but all costing several
hundred dollars. I'm hoping that Excel can do what I need it to do. Please
help!