=SUM(INDIRECT("'"&A1&"'!C4:D18")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg114" wrote in message
...
Hello,

I have a workbook with 10-15 worksheets with different names. I am trying
to
set up a "Summary" worksheet that will have each worksheets name in column
A
and then two summed columns with data from each worksheet (C4-D18 and
D31-E52).

Is there a way to reference the worksheet names in Column A within a
formula? For example, in place of SUM(Worksheet1!C4:D18) I'd like to
reference the worksheet name in column A - SUM("Column A"!C4:D18).

Thanks in advance for any assistance.