Instead of add Header and Footer information individually to worksheets, you select the worksheets creating a "Group".  This will apply the changes to all selected worksheets.

1. Press and HOLD the Ctrl key and select the sheets you want to include.  Notice at the top of 
    the toolbar the word Group is inserted beside the workbook name.
2. Click on File, Page Setup and then Footer.
3. Select the information you want to include and this will print on all the sheets in the workbook. 
    Make sure to include header info as well.