Best way to have word to show which words uniquely show in list 3 that are not in list 1 and 2, 4, 5 etc.

[Zelmai]

In the attached spreadsheet, in sheets b1, b2, and b3 the first column contains a list of words. In column f of b2 I have formula that compares column a of b2 with column a of b1 and shows all the unique words. This is fine.

However I can't figure out a way to in b3 have column f compare the list of words in column a of b3 with both column a of b1 and b2 and list out words that don't appear in either column a of b1 or column a of b2.

I plan to add lots more sheets, about 65 total and each new sheet will need to see which new words it presents that aren't in column a of any of the previous sheets. So it would be helpful to have the easiest way possible to do this.

 

[Zelmai]

Here is the formula in sheet b2 f2
=FILTER('B2'!A2:D1000,if('B2'!A2:A1000="",FALSE,nOT(ISNUMBER(match('B2'!A2:A1000,'B1'!A2:A1000, 0)) )))