Simple Formula to calculate percentage and productivity

I know this should be an easy fix, but for some reason I can't figure it out. I have to send a table every day with the production for each site for each day. I can calculate everything, press a button and it will sort them by ranking. But that's where the problem begins. The first table (previous day) have the information sent on Friday for the week before. On Monday I put the new information on the second table. That one is working fine since the information on the first table is stationary. I don't have to rank it. But for Tuesday and on (3rd - 7th table), every time I enter numbers for one location, I want to calculate the difference between that day and the day before. The problem is that when I send the table already sorted by ranking, that row moves up or down depending how they did that day. So when I enter the information for the next day, the formula is referencing the wrong row (location). for example, I'm located in Tampa. Alphabetically we are the last row, but if we are doing good we might be at 2nd or 3rd place.. which will move the entire row up to that position. The next table needs to pull information from the previous one, which Tampa will be the last row again, but the information needs to be subtracted for the previous table is not on the same location any more..

I hope i'm making sense. I know it's a long explanation, but I'm not sure if I'm explaining this clearly. Please advice any ideas... Thanks..

Here i attached the original book.SUMMARY REPORT.xlsm

Perfect.. It works nicely. Thanks a lot.. and thanks for the quick reply. I really appreciate it.

Sorry to bother again.. I have another table that I need to implement the same type of formula you sent me to do something different.

I work on a call center monitoring calls. I score each call and the system grants points. anything over 90 is a pass, 89 or below is fail. I want to calculate how many passes and how many fails on each site. For example I have 3 people from bogalusa, I scored only 2 of them. I want the table to show Bogalusa - 3 Pass 1 Fail. Same thing with each one of them. Following the same example in the sheet attached, Layton has 3 people. 2 fail and 4 pass. Each person gets monitored 4 times per month. (im showing only 2 here.. round 1 and round 2). I also want to make sure that the calculation does not include any of of the information in between the columns with the score. so in this example the scores are column I and N. Thanks again.

I can use it like that, the S means the call was in Spanish.. I can enter that info anywhere else.. Thanks again. It was simpler than I tough.. I just dont have the imagination to think how to calculate it.. Thanks again.