I have Sheet 1 as my master list of infomation.

100023 red
100048 blue
100589 yellow

Sheet 2 contains infomation to add

FI 100027 purple
FI 100048 blue

Sheet 3 contains information to delete

FO 1000589 yellow

I need the master sheet to automaticly or by macro button
add any new files in Sheet 2. So it would only add the
purple row because blue is already in the list.

And Sheet 3 information needs to be deleted from the
master Sheet, so yellow would be deleted.

Any additions need to be appended to the bottom of the
master list.

The result would be in the master sheet:

100023 red
100048 blue
100027 purple