Pull data from separate sheet, then stop updating once pulled.

maso1687 

I would go about this very differently. And I'm speaking as a person who for several years was the director of the HR/Payroll database for a major US corporation and had to product monthly headcount reports. I can't imagine doing so on a daily basis, as it appears you're doing, but I think the methodology would still be the same.

The heart of our process was a database that can best be described as transactional: i.e., we recorded each transaction affecting each person. I would assume that somewhere your organization must have something similar. For your purposes (tracking headcount) the most relevant pieces of information would be date of transaction, nature of transaction (Hire, Termination, Job Change, etc), position classification (Full time, Part time, etc), Division, Location, and maybe one or two other characteristics important in tracking headcount.

From such a database, a well designed query could count the number of people currently employed on any given day and do so by classification, location, etc.

Now, we were counting people in the tens of thousands, so there may not be transferability to your situation. But I start by mentioning that by way of background. Your process as described here seems to be picking up the daily number(s) in a very different way, just counting people on the job at two sites and recording a number daily.  But it makes me wonder what other data you do track--surely you need to be paying people, and therefore there is some sort of transactional database behind THAT process, if not connected currently to yours. But could it be?

That said, granting that you might not want to change your basic process, is it possible for you to post a copy of the spreadsheets from which you got those images; i.e., post the actual spreadsheet, on OneDrive or GoogleDrive, pasting a link here that grants edit access to that sample. That would help us help you.