Formula to add to table from previous day report

[dpston]

Hello,

I have to turn in daily reports that require me track man hours that were spent on different tasks. I have a table that has them all broken up by the task and I have: "Hours Today", "Previous Hours", "Total Hours" "Hours to Use" and "% Completed".

The intent of this is to put how many man hours for each day in the "Hours Today" column, add that column to the "Previous Hours" column and that will equal the "Total Hours" column. This would then change my "% Completed" column on a daily basis.

The formulas for all of that are very simple and can be done. My question is if there is some formula or way to bring the "Total Hours" column from the previous day in to the "Previous Hours" column in my template and keep a running total without actually having to get the data from the previous work sheet every day. For instance, I would like the total from file "11-29-2018" to be in the column for "11-30-2018". Then, I would like the increased total from "11-30-2018" to appear on "12-01-2018" and so on.

I don't think that there is a way to do this. But, if there is, I imagine someone on here would know how to do it. I am attaching the file to help with any confusion that I might have created. Thank you for reading and helping.

[rcm]

Attached please find 2 excel files. I took the liberty of integrating the date in univarsal format into the name. It is needed to automatically fetch the data from the previous day.