help auto sum and total sum on expanding sheet & create historical table + master and working copy

I suggest you try to make this easy on yourself. Some suggestions:
- Try to get all your data into one single flattened table
- Make sure this table has separate columns for date, location and any other type of information you would want to get sub-total amounts grouped for
- Do not enter any formulas within that table, this is data, not your report.
With your data well structured, creating your report is as simple as inserting a pivot table using your new table of data as its source. No formulas needed whatsoever.