Enter data in multiple worksheets at the same time in Excel 2007

Data entered in a cell can be produced exactly into other worksheets with out performing the copy & paste thing. For example, if your workbook has 3 sheets labeled Sheet1, Sheet2, Sheet3 and in Sheet1's B5 cell you enter Excel 2007 tips then the same data will appear in cell B5 in Sheet2 provided that you had selected Sheet1 and Sheet2.
In other words, you group worksheets by selecting multiple sheets. Enter some data in the selected sheet and see the exact data appear in other sheets.
To select multiple sheets, do the following:
Selecting all worksheets: Right click on any sheet tab and click Select All Sheets.

Selecting adjacent worksheets: Click on a worksheet and then press the Shift key. Keep the Shift key in pressed state, click to select the last worksheet.

Selecting non-adjacent worksheets: Click on a worksheet and then press the Ctrl key. Keep the Ctrl key in pressed state, click to select other worksheets.

Now enter some information in any of the selected sheets. You will see the same information in other worksheets. Clicking unselected worksheet tab ungroups the sheets.