Add Sheet, Copy Data With Validation

Their is sheet in which some online data is comeing.

#1 I have to copy that data in another worksheet and its name shud be last 3 characters of the sheet in which data is comeing.
Say for example data sheet is abcd_2781 so new sheet name shud be 781

#2 now i have to copy the data based on certain validation
the sheet has 14 colums

the data keep coming in....every time it comes with a unque ID.
but when it comes there is a colum which tell us three operations
0=NEW
1=change
2=DELETE

And so when ever we copy data it shud only copy 0,1,2 it shud not copy new, change or delete.

Now there is one more colum in which their is entry ID, it carried diff ID for NEW transactions. But when ever their is change or delete it will be same what ever was generated when it was new. so the validation shud be

when its 1= change it should match its Entry ID and delete the complete ROW with all previous same ID keep this only

When its 2= Delete it should match its Entry ID and Delet the complete row with all same including itself.

i am attaching the input and out put data
Input data Output data
MDUpdateAction MDEntryID MDUpdateAction MDEntryID
0=NEW 100302 0 100302
0=NEW 100303 0 100305
0=NEW 100304 0 100306
0=NEW 100305 0 100314
0=NEW 100306 0 100313
0=NEW 100314 0 100315
0=NEW 100313 0 100316
0=NEW 100315 0 100293
0=NEW 100316 1 100291
0=NEW 100291
0=NEW 100292
0=NEW 100293
2=DELETE 100303
2=DELETE 100292
2=DELETE 100304
1=CHANGE 100291