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.