Enter or Edit the same data on Multiple Worksheets
When you select a group of sheets, changes you make to a selection on the active sheet are reflected in the corresponding cells on all other selected sheets. Data on the other sheets may be replaced.
Select the worksheets where you want to enter data.
Select the cell or cell range where you want to enter data.
Type or edit the data in the first selected cell.
Press ENTER or TAB.
Microsoft Excel automatically enters the data on all selected sheets.
To cancel a selection of multiple sheets, click any unselected sheet.
If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.
If you've already entered data on one worksheet, you can quickly copy the data to corresponding cells on other sheets. Select the sheet that contains the data and the sheets to which you want to copy the data. Then select the cells that contain the data you want to copy. On the Edit menu, point to Fill, and then click Across Worksheets.
You can also refer to the same cell on multiple sheets without entering the data.