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.

Is it possible how the result should be displayed . In a column (M) in your file or any other way.

You could try and test this incomprehensible formula in the single cell M7:See attached.
Named range not required, no Power Query query.


Edit: Added the equivalent named lambda formula in cell N7.
2024-08-02_170342.jpg

If you want to transfer this named lambda function to your own workbook, an easy way is to copy my worksheet to your workbook then immediately delete it from your workbook; the function should remain.

Attached Files

msofficeforums52670EXAMPLE_v02.xlsx (119.6 KB, 2 views)