Hi, first time poster. Hope someone can help.

I am trying to create a Daily Sales Workbook with one sheet acting as
the YTD report.

I would like to create a formula on the YTD sheet that pulls the value
of a constant cell location throughout the entire workbook.

for example all of my C33 cells, on every monthly sheet, represent
total blue widgets sold.

on my YTD sheet I would like to SUM all the C33 cells and populate that
value.

I can create a formula manually by adding Sheet1!C33+Sheet2!C33 etc,
but I thought there must be an easier way.

I found the GLOBAL NAMING instructions which will define a cell to be
called by any other sheet in the workbook, but I want to do the exact
opposite. Or maybe define the cell on the YTD sheet and then push the
infomation to the GLOBALLY defined cell.....

I am sure the answer is right there but I am not seeing it.

also I am wondering if the formula remove the requirement of creating
all the sheets in the book ahead of time?

Thanks in advance for a probably silly question.