Creating IF function and/ or a macro if needed

Christina Marsh
Occasional Visitor

There are 8 routes and when the total is calculated in cell G22 on each tab I need that total to populate in the totals tab for the corresponding route AND day of the week. then I need the totals to advance to the next week ending date so the clerk can reuse the form in the corresponding tabs. Please if you can help with either of these it would be appreciated, the file is attached.