YTD on Excel Fuel Reconciliations

Use a separate block of cells that have formulas to gather the data for interest from the sheet, using this kind of logic:

=IF(cell with criteria for completed sheet,value of interest,0)

like

=IF($Z$1,A10,0)

where Z1 has a formula that returns FALSE until the criteria is met, when it returns TRUE.

For example

=AND(Q10<>"",Q20<>"",Q30<>"",Q40<>"")

Use as many of the IF formulas as needed to pull all of your data.

Just as an aside - you would be much better off using one of your sheets (as a report) and a sheet that works as a database, where one row is filled for every day, and has all the information that you would normally fill out for a day's area. Fill the report sheet with formulas to extract the data required from the database, based on a key value in a cell, like the first day of the week of interest's date. The database would allow you to filter, subtotal, and use a pivot table to extract other reports, which is the true power of Excel.