Assuming you want to sum 10 values from cell B1 (one for each sheet)

=sum('Sheet2:Sheet11'!B1)

copy as needed

If your sheets are not named Sheet1, Sheet2, etc., then start the formula
normally by typing

=sum(

then click on the leftmost tab, click in the cell you want to sum, hold the
Shift key down and click on the last tab to sum, then press the Enter key



"maura" wrote:

I have 10 worksheets (all are formatted the same), and I want to take all of
the information out of the same column in each worksheet and combine all the
information from that column into another worksheet. What would the formula
be?

Thanks, maura