I have the same problem in Word, but understand now that you enter "Section Break" to achieve different header/footer on each page....but Excel doesn't give you that option.

How do I create different headers on each page of my Worksheet?

thanks