I have been searching all over the place for a way to do this.

I have data on sheet1

place time
home morning
school afternoon

data on sheet2

place time
home morning
school afternoon
office night

After running a macro, sheet3 should be able to display

place time
office night

Above is an example I am trying to work out. My data itself consist of a few hundred rows.