Hi,
I have gone through your project details and would like to take an opportunity to work on it. I have worked on number of excel and ms access projects so can provide you efficient solution in access.
As you are maintaining data in excel currently, in access you will get forms and when desired input is entered you can get reports on weekly and location basis.
More details can be discuss on chat. Waiting for your response on it. Thanks.