SUMPRODUCT - Adding New Data Daily

This was the point I made when this spreadsheet was being created and was over-ruled. So it is best to just discontinue the summaries in their current format and switch to summaries on a new tab?

My boss literally just wants summaries by agent, by day, by week. The method above was his method of choice and it is a lot of work and seems like a long way for a short cut. I'd rather all the summaries updated automatically as soon as new data is entered. The source data IS formatted as a table, which usually updates formulas automatically or with the click of a button if put through a pivot, but that is not working here. I am manually having to resize the table too. I think this may be because the data within some of the columns is referenced from different tabs within the same workbook and not "keyed" data. Is that right?

Thanks