Multiple Worksheets and Data Consolidation

In the older days of spreadsheet programs, you were restricted to a single sheet with 256 columns and approximately 8000 rows.  A problem that many people discovered was trying to create formulas that required data from many different locations on the same spreadsheet, even though the data was basically the same.  Eventually, the concept of mutliple worksheets in the same file came to pass.  Not only does this allow users to create the same kind of data on different sheets easily, but formulas and functions are much easier to understand.  In this section, we'll discuss several items dealing with mutliple worksheets.

• Adding, Removing, and Renaming Rorksheets
• Grouping Worksheets
• Creating Multiple-Worksheet Formulas and Functions
• Linking Data from Other Workbooks
• Consolidating Data