The problem with having just a single Count column as the output is relating each row of the count robustly with a module number.

So, with 5 aircraft/sheets, you'll be processing each sheet in the same way. You'll have 5 queries producing comparable results.
It'll probably be simplest to merge/join or append the 5 tables. Each table will be identifiable, so you'll be able to produce a single table with data integrity in your 'comparison' tab, probably all within Power Query.