Comparing Multiple Sheets and Removing Existing Rows

[Vicate]

Greetings,

I attempted a search but could not find any issues similar to mine.

For my job, I am trying to keep track of the number of issues and have created a pivot table to show by type, state, etc. which works fine.
I copy+paste the data directly from a log (from a company program) into this excel sheet.
For each daily shift, I have a separate sheet (I'd like to keep it this way).

*For identity purposes the information below is fake, but formatted exactly how I would like*

Sheet 1(Shift 1):

[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]State[/TD]
[TD]Issue Type[/TD]
[TD]Resolved?[/TD]
[/TR]
[TR]
[TD]Michael[/TD]
[TD]Ropero[/TD]
[TD]FL[/TD]
[TD]Tech[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Sandra[/TD]
[TD]Stuart[/TD]
[TD]GA[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Cynthia[/TD]
[TD]Robertson[/TD]
[TD]CA[/TD]
[TD]Other[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Emmanuel[/TD]
[TD]Gonzalez[/TD]
[TD]CA[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]


Sheet 2(Shift 2):
[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]State[/TD]
[TD]Issue Type[/TD]
[TD]Resolved?[/TD]
[/TR]
[TR]
[TD]George[/TD]
[TD]Phillips[/TD]
[TD]MO[/TD]
[TD]CService[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Michael[/TD]
[TD]Ropero[/TD]
[TD]FL[/TD]
[TD]Tech[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Sandra[/TD]
[TD]Stuart[/TD]
[TD]GA[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Ruben[/TD]
[TD]Grimes[/TD]
[TD]MO[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]Kimley[/TD]
[TD]NY[/TD]
[TD]CService[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Cynthia[/TD]
[TD]Robertson[/TD]
[TD]CA[/TD]
[TD]Other[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Stephen[/TD]
[TD]Hess[/TD]
[TD]FL[/TD]
[TD]CService[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Emmanuel[/TD]
[TD]Gonzalez[/TD]
[TD]CA[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]


Sheet 3 (Shift 3):
[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]State[/TD]
[TD]Type of Issue[/TD]
[TD]Resolved?[/TD]
[/TR]
[TR]
[TD]George[/TD]
[TD]Phillips[/TD]
[TD]MO[/TD]
[TD]CService[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]Holmes[/TD]
[TD]CO[/TD]
[TD]Other[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Betty[/TD]
[TD]Strum[/TD]
[TD]FL[/TD]
[TD]CService[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Michael[/TD]
[TD]Ropero[/TD]
[TD]FL[/TD]
[TD]Tech[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Sandra[/TD]
[TD]Stuart[/TD]
[TD]GA[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Dustin[/TD]
[TD]Hoffman[/TD]
[TD]SC[/TD]
[TD]CService[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Robert[/TD]
[TD]Wagner[/TD]
[TD]MO[/TD]
[TD]CService[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Ruben[/TD]
[TD]Grimes[/TD]
[TD]MO[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]Kimley[/TD]
[TD]NY[/TD]
[TD]CService[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Cynthia[/TD]
[TD]Robertson[/TD]
[TD]CA[/TD]
[TD]Other[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]Nihal[/TD]
[TD]CO[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Stephen[/TD]
[TD]Hess[/TD]
[TD]FL[/TD]
[TD]CService[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Emmanuel[/TD]
[TD]Gonzalez[/TD]
[TD]CA[/TD]
[TD]Tech[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]

As you see, my company's software does not remove entries from previous shifts, but I would like each sheet to only display NEW entries to each shift, and remove those that were in previous shifts after I copy+paste from the log.

To use the above sheets as an example:
Sheet 2 should remove the entries that are already present in Sheet 1
Sheet 3 should remove the entries that are already present in Sheet 1 and Sheet 2.

I would like to create a macro or any other way to achieve this.
Any assistance is greatly appreciated. Thanks!

 

[Vicate]

I also need to include that there can be as many as 2000+entries being copied per shift and as many as 8 shifts(sheets) per day I would like to compare to.

Thanks in advance!