I am needing to track expenses for each week of the year. Column D will
total various Year-To-Date expenses from the previous week.

The Total YTD expenses for worksheet Week2!D2 would add the total
expenses on Week1!D2.

If I use =SUM(Week1:Week52!D2) I end up with the same value on every
worksheet. I do not want to include forthcoming weeks value.