Select the left most tab in your workbook.
Hold down the shift key and select the right most tab.
This will group the sheets and any changes you make will be made to every sheet.
Be careful not to enter any data in a cell or change formatting, etc. When sheets are grouped, any changes made to one sheet will be reflected across all sheets in the group.
Select any sheet in the group if they are all grouped, or a sheet outside the group, to ungroup them.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.