Running Total that Feeds from Overwritten Cell

[Adamac13]

Hi Everyone,
I've tried a few macros as well as formula combinations and am coming up empty handed.
Hoping someone can help me out.

Essentially I record hours for a few employees on a weekly timesheet. On any given day an employee can be tagged to a single job with the potential to work multiple jobs in one week.
What I am trying to do is keep a running total of how many labor hours are being allocated to each of these jobs as well as keeping a running total of yearly hours for each employee.

The tricky part is that I need to have one "Master timesheet" that I fill out each week. This means that data is being recorded on the same file each week and the data from the week before is constantly being overwritten and then saved as a new weekly file. (as opposed to one ongoing list of hours)

So for example, if i have employees Mike & Todd working on jobs "A""B""C" and "D" is there a way that I can have their hours both tallied by employee as well as job even when the data is being overwritten?
To add one more layer of complexity i also need these hours to be broken out into ST, OT, and DT as well as position code which I record on the "Master Timesheet" in separate cells.

I'm attaching an excerpt as an example of what the "Master timesheet" looks like as well as how I am currently keeping track of Job and Employee hours manually. I'd like the timesheet to feed into these two other reports weather it be in one worksheet/workbook or any other format that you come up with.

I'm also very open to any other alternative solutions. (I've come up with a few myself, however they feel quite "clunky" for lack of a better term)

Any insight you could provide is much appreciated.
Thank you!

[Tsjallie]

Took a look at your workbook.
To achieve what you want will need a change in your approach anyway.
The change would involve a table in which all details are stored.
Depending on your appetite for vba you could use this table as your master time sheet and fill the other forms from there. This would be a vba-less solution.
Alternatively you could have some vba in the Worksheet_change event which stores date entired in you current mater sheet into the table or reads data back from it into the master sheet.
Personally I think that the latter solution would be nicer and stay closer to yur current approach.
Doing without that table and exchanging data directly between the master timesheet and the other forms wouldn't be reliable.