Missing sheets detection

Yes, you can use the Categories node to select Sheets and connect that to All Elements of Category. You can import from excel using Data.ImportExcel node. Then, compare both lists using the methods explained here Lookup value in a list and place it in other list - #3 by Robert_Klempau
Hope it helps!