You can create an accumulation WorkSheet/Book with what are called "3D" Formulas. Hopefully the entries are laid out pretty much the same on each sheet.
Create a Total for each piece of pertinent data. (?TotalSales98?, ?TotalCostsMay99?, etc.)
Name that cell or range. (An easy way is to select the cell and then enter the name in the Address box ? where you see B34 ? and hit enter.
If you have all of the sheets in one book, you can then set up an accumulator page with formulas like = (TotalSales98+ TotalSales99)-(TotalCosts98+TotalCosts99).
If they are in separate workbooks, it?s a little more difficult, but not that bad. Start the formula in the accumulator (type =) then open each book and select the cell you want. Type a arithmetic operator (+ - /) and the click the next cell.
If the cells are laid out the same way on each sheet, you can drag the formulas and they will automatically adjust them selves. Let me know if you have any questions, it?s a little difficult to tell you exactly what to do without more information.