I have two seprate but related questions. I have a few excel workbooks with
multiple worksheets (nearly 30 worksheets in one of them). Each of the
workbooks has a summary page. Here are my two SUM related issues:

1) I need to add values in the same cell across the multiple sheets... is
there a way to do this without typing a gigantic formula:
ex =sum(sheet!A1,Sheet2!A1,Sheet!A1.....Sheet30!A1)
Basically, is there shorthand for adding across all or many worksheets?

2) One of the workbooks has each month split onto a separate sheet. I need
to be able to query across the sheets and sum items based on certain
criteria. The items are not on identical rows... but they are on identical
columns.

ex
Worksheet 2 (February)
Widget1, Price3, QuantityC

Worksheet 5 (May)
Widget1, Price2, QuantityG
Widget3, Price1, QuantityH

Worksheet 7 (July)
Widget1, Price2, QuantityZ
Widget2, Price4, QuantityG
Widget3, Price6, QuanitityY

I need to be able, on my summary page, query all worksheets and find line
items that include Widge1 and then add all related prices or all related
quantities. Or, find all widget1 items that ALSO were at Price2... and add
those Quanitities.

Again, not haveing to type in a super long formula would be great.
Hope that makes sense.