Transfer Daily Data from Daily Staffing Workbooks into a Running Annual Summary Workbook

Hi. I am trying to make my life easier. I just inherited a bunch of workbooks used for compiling data where all the data was entered manually from a daily workbook into an annual summary workbook. It seems to me that transferring this data manually is tedious and unnecessary. So what I would like to be able to do is transfer data from these daily workbooks (the data on these is entered by others manually, daily) into a summary workbook, via programming, so that I do not have to manually enter the data. This will make more sense by looking at the attached examples (they contain just numbers, not personal or sensitive/confidential info).

I am only concerned with the "Tally Sheet" tab of the sample Daily Staffing Workbook attached (these are named sequentially by date as: "ST 10-01-15" "ST 10-02-15" "ST 10-03-15" etcetera, same format each month (so November is named "ST 11-01-15" "ST 11-02-15" etc.) for each day for the entire year. The sample Daily Workbook I have attached here is named: "ST 10-04-15.LN Edit"

In the sample Annual Summary report it is the "Raw Data" tab that I am looking to auto-fill as the other tabs are all pivot-tables and graphs that are fed from the data in the "Raw Data" tab (I had to delete all the other tabs from this workbook because the file was too large to upload as an example, but I did upload a screen shot of the complete workbook with all the tabs to demonstrate what this workbook does in case anyone has any good ideas on how to do this a better way). I also deleted all other data except 10/3 & 10/4 for the same reason bbut would be happy to e-mail complete sample workbooks if it helps). The sample I attached has 10/3 & 10/4 of October already completed manually; you can see how tedious and unnecessarily labor-intensive this is. October 4th's data has comments in the various cells to explain where that data comes from in the "Tally Sheet" tab of each Daily Workbook, and this data corresponds to the data in the sample Daily Workbook attached.

If anyone can help it would be greatly appreciated - thanks!

Well, I could discuss this with the manager of the folks that do the data entry on the daily sheets....can you suggest what the "bit of adjustment" would be that you are suggesting above? I am not sure how I would do this, given that the "summary" workbook is already kind-of unwieldy. Though maybe I could restrict access to certain tabs and not even let the other users see the tabs that don't pertain to them? I'm open to suggestion...


Thanks!

The tally sheet already has the d/e/n totals I need from each of the three sheets used to enter data. I could not just add a column for each; there are many areas of each sheet that change by shift...hence the tally sheet to compile them. That is what I essentially want to do; use the tally sheet to feed the ongoing annual summary....
I am not sure how to accomplish what you are suggesting...I don't know how I could combine the 2 workbooks into one and still capture all the data essentially in the formats that they are in (that's how the boss wants it).....

I see now; so the "input" sheet would take the place of the three tabs for d/e/n and be the continuous, running list itself. Then the summary (or even presumably the actual input sheet) could be used for the pivot tables, graphs, etc. I see how this would be easier from a programming standpoint....I will consult with other(s) at work and see if that would be acceptable. Unfortunately my initial feeling is that it would not and I may have to seek a solution to this the more difficult way. Thanks for your responses so far, very helpful!

Thanks. I am hedging my bets (folks at work can be resistant, lol) so would still be interested in how to go about it the other way, but will explore the above with the folks at work even as a future place to get to, to make it easier going forward...maybe I could get them on board for 1/2016....thanks again!