To simplify:
The Main file in the database is now linked to includes:
Employee ID, Date, City, Revenue, Quarter and Year
These are across several years now. I use the Quarter and Year column to differentiate between the reports. They are now one table.
Each week I add the additional rows...