MATCH INDEX, or something else???

I need to populate the worksheet below with miles for each route (Row 2) every day (Col. A) from 6 different worksheets.
Excel1.png

I have 6 different worksheets formatted as below. I need to get the miles in Col. I to the correct cells in the worksheet above ("Recorded Daily Mileage") by matching Cols. A and N to Col. A and Row 2 on the above worksheet.
Excel2.png

I believe this is possible using MATCH INDEX, but not sure... Can someone please point me in the right direction? I don't need explicit instructions, just need to spend time on something that I know can work...

Thanks for any advice!

I believe the solution is a pivot table.

1. Combine all 6 different worksheets into one data set as to able to pivot on it.
2. Create pivot table from new data set
Row Labels = "#"
Column Labels = "Date"
Values = Summation of value "Miles" Change from "count" to "sum" in value field settings.

The newly created pivot table should be a mirror of the "customer-facing" table you want.