Tough question moving data (may require macro?)

[Josh Craig]

I have data in columns and rows in different sheets.

Each sheet is the name of a company and contains data about the company.

I need a summary sheet.

What I want in the summary sheet is:
column A: Sheet Name
column B: sum(c41,c49) from each sheet
column C: sum(d41,d49) from each sheet
column D: sum(e41,e49) from each sheet
and so on...

Any ideas how I would accomplish this?

 

[ryguy7272]

This question comes up every once in a while.
=SUM(Sheet1:Sheet3!C1:C45)

HTH,
Ryan---