|Still not sure what it is you want, |
but from what I can see on your sheets,
it would appear you want a cumulative total.
You have two Sam's on what I think is the Monday Sheet,
so to get both subtotals copied to the Weekly Total sheet,
Where B1 thru B5 are the Subtotals cells.
Please follow DerbDad03 request, and read the HOW-TO he posted,