You can insert or add Header and Footer in Excel spreadsheet using this tutorial. Insert page number, current date and time, etc.

You don't have to add a header to every Excel worksheet individually when you can group them first.