Insert a new sheet (and hide that sheet if you want.

Then put a formula to retrieve the value from each worksheet in each workbook in
its own cell.

Say A2:Axxx

Then you can use
=sum(a2:a65536)
in A1 to get the total

And use that single cell in your formula on the other sheet.

Eric wrote:

I have a workbook that contains four worksheets. This workbook is a budget
request "form." I will have mulitple units completing this workbook. So,
when all is said and done, I will have 17 workbooks (budget requests). I
want to be able to sum all the data up in another workbook which will
represent the totals.

I have tried to create a formula (= _______+_________+, etc.), where the
blanks is the same cell in each of the 17 workbooks. Excel would not let me
create the formula because I ran out of space (formula too long).

Any ideas on how to get around this?

--

Dave Peterson