if a have two set of tables in two different sheets,,

i.e.

session1 - Table1(sheet1)
email Attend
yes
yes
no

session2 - Table2(sheet2)
email Attend
no
yes
no

can i create a new table at a new sheet showing me who didnt attend the two
sessions,,

help will be highly appreciated,,