Copy Duplicates from different Worksheet to another Worksheet

Please Help!! I need to know what form are used and who used it.
I have the production tab where the total production per year from all agents are based.

I have thousands of entries and attached is an example of my data.
I used manual formulas but everytime i edit a thing excel lags. is there any way i can make it simplier?

i am planning to copy duplicates from a Production tab and every form tab to another tab.

Help me Please. Thanks