I think you're on to something, but it's not that I want to sum all of the
cells, only if a particular cell matches another.

For example:

=SUMIF(First:Last!D2,'Summary Raw Data'!A2,First:Last!D4)

The response I receive from this is "VALUE" and I suspect it's because sumif
doesn't work across separate worksheets?

"Rowan Drummond" wrote:

One way. Assume you start with 3 sheets. Summary (or whatever your main
sheet with the caluclations is called), First and Last. In the Summary
sheet you can enter the formula:
=SUM(First:Last!$A$1)
This will sum the values in Cell A1 in the sheets First and Last. Now if
you add any other sheet to the workbook and place this sheet between
First and Last that sheets cell A1 will also be included in the result.

Hope this helps
Rowan

adodson wrote:
Ok... first I would like to say thank you to anybody who attempts an answer
for this... I really appreciate any ideas.

What I would like to do is to have a workbook with a worksheet that pulls
from specific cells on other worksheets. The kicker is that other worksheets
are added as they are turned in so they are not in there at the beginning.

I'm guessing this (if at all possible) would have to be done with code...
any ideas?

Once again, it's a very simple go to other spreadsheets (I could probably
manipulate it if it looked at all) and pull a specific cell back to the first
worksheet. Would be helpful if it also ordered them by the first cell it
pulls back in.

Again, thanks for any assistance.