Excel 2010 has a feature that will allow you to set-up multiple sheets at a time with the same formatting and data. So, if you normally copy and paste the data and formatting to each sheet in workbook, you will be able to to do it all in one step.

1. First, open your workbook, hold down your CTRL key and select all your worksheets (the sheet tabs will all be white rather than gray with just the selected tab white). This will group your sheets. All changes done while your sheets are grouped will apply to all sheets

2. Now insert your data and formatting. You can insert data and then format in any way that you like.

Sheet 1 Formatting

3. Once you are done, click on any of the other grouped sheets to see the data and formatting (make sure you click on any other sheet to ungroup the sheets before you insert anything that should just apply to one sheet).

Sheet 2 Formatting

This will make sure that all your data and formatting are uniform across all sheets and will save steps later on when needing to set-up those sheets.