How can I do calculations on multiple fields on multiple worksheets

If you're just trying to get the YTD, or YE totals, you can just SUM all the cells with the specific data you're looking for.

Formula:

=SUM('Week 1'!D2,'Week 2'!D2,'Week 3'!D2)

This formula would return the YTD salary on your sheet.