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):

First Name	Last Name	State	Issue Type	Resolved?
Michael	Ropero	FL	Tech	N
Sandra	Stuart	GA	Tech	Y
Cynthia	Robertson	CA	Other	N
Emmanuel	Gonzalez	CA	Tech	Y

<tbody>
</tbody>

Sheet 2(Shift 2):

First Name	Last Name	State	Issue Type	Resolved?
George	Phillips	MO	CService	Y
Michael	Ropero	FL	Tech	N
Sandra	Stuart	GA	Tech	Y
Ruben	Grimes	MO	Tech	Y
Chris	Kimley	NY	CService	Y
Cynthia	Robertson	CA	Other	N
Stephen	Hess	FL	CService	Y
Emmanuel	Gonzalez	CA	Tech	Y

<tbody>
</tbody>

Sheet 3 (Shift 3):

First Name	Last Name	State	Type of Issue	Resolved?
George	Phillips	MO	CService	Y
Mike	Holmes	CO	Other	N
Betty	Strum	FL	CService	N
Michael	Ropero	FL	Tech	N
Sandra	Stuart	GA	Tech	Y
Dustin	Hoffman	SC	CService	Y
Robert	Wagner	MO	CService	Y
Ruben	Grimes	MO	Tech	Y
Chris	Kimley	NY	CService	Y
Cynthia	Robertson	CA	Other	N
James	Nihal	CO	Tech	Y
Stephen	Hess	FL	CService	Y
Emmanuel	Gonzalez	CA	Tech	Y

<tbody>
</tbody>

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!