Headers/Footers in Worksheets/Workbooks

Sure - select the first sheet you want the header to appear in, then holding down the shift key on your keyboard, click the last worksheet. This groups them. Then go into your header and design as needed. To include sheets that are not next to one another, hold down Ctrl while clicking. Caution! If you forget to ungroup your sheets, when you are editing any of them in normal view, changes will apply to all sheets in the group which could cause you to overwrite values, so remember to ungroup them when you are done designing your header.