How do I Add Information on Excel Worksheets to a Summary Sheet?

Excel 2003
1. Open Microsoft Excel and open the sheet you wish to summarize. Click on the 'Tools' menu and choose 'Scenario.'
2. Click on the 'Summary' option and choose 'Scenario Summary.' Go to the 'Result cells' tab.
3. Enter the cells you wish to summarize. You can simply place your cursor on the first cell and drag it to the last cell to create your range.
Excel 2007
4. Open Microsoft Excel and find the spreadsheet you want to summarize. Go to the 'Data' tab.
5. Go to the 'Data Tools' group and then the 'What-If Analysis-Scenario Manager.' Click the 'Summary' button.
6. Choose the 'Scenario Summary' option and enter the range of cells you wish to summarize. You can select the cells by highlighting the first one and dragging your cursor to the last one.