I also looked at your sample file to try to understand the problem. It occurs to me that there may be a more efficient cloud-based solution to the way you are currently distributing your data.
My understanding of the problem is that you have a table containing multiple rows of data. One of the columns contains a field called "Unit". You need to distribute a subset of this data (filtered to a single unit) to each unit each day.
The Current Solution
You are manually copying the data (for each unit) from a master workbook into one workbook per unit. You then place these workbooks in shared folders so that the each unit has access to the data.
Data Structure Issue
Though unrelated to the problem, I would advise that you consolidate your Agency FY 2015 workbook into a single table rather than have a different worksheet tab for each month. It will then be very easy to filter by month if you need monthly summaries. The advantage of this approach is that you’ll be able to perform monthly analysis on the current and past months via a single pivot table. You'll also be able to produce quarterly and annual summaries with just a couple of clicks when your data resides in a single table. Pivot tables are extensively covered in: Expert Skills, Session 5: Pivot Tables.
There are many solutions to every problem. It is often the case that you find yourself focusing upon the implementation of the solution rather than the actual business problem. The problem is that each unit needs up-to-date (ideally real-time) information about their activity.
It is unclear whether the data is confidential. In other words, whether one unit is not allowed to see what the other units are doing. For the moment I’ll assume that there is no issue regarding one unit seeing another unit’s data.
If this is the case why not publish a pivot table via the cloud that personnel with the right password could access using any web browser (including pad devices or mobile phones).
Publishing to the cloud is extensively covered in: Session 8: Cloud Computing, OneDrive and Excel Online. The OneDrive will automatically synchronize to your local file so your users will see your data seconds after you enter it into your workbook.
You’d end up with something like this:
Units could then double-click on the total hours’ figure to see individual transactions.
You could then add slicers to enable users to summarize and filter data using simple touch controls by whatever criteria was useful.
Filtering pivot tables using slicers is covered in: Expert Skills, Lesson 5-8: Filter a pivot table visually using slicers.
If you wanted to base the pivot table upon a new consolidated table showing all months and all years you could also provide a time-line control to enable users to review any past month, year or quarter's performance.
Adding a simple time-line control is covered in: Expert Skills, Add a timeline control to a Pivot Table.
And adding a more advanced set of timeline slicers is covered in: Expert Skills, Lesson 5-10: Use slicers to create a custom timeline.
Everything would then be real-time and you wouldn’t have to do a thing to provide up-to-the-second information to all of your users.