Dear Engr Aurangzeb ,
Kindly find the following steps to check what is wrong with you ,
1- Check the numbers of rows in each building type and the number in the Combined BOQ ” for Example : in Villa V1 sheet number of rows with data = 288 and when i make filter in the combined sheet with text contains Villa V1 number of rows with data = 288 the same in the two sheets.
repeat this check with all the sheets , you can know the number of row from excel as shown in the attached photo
2- check the sheet start row in the sheets before combined and the first row the macro select , you can check it for the macro code
3- you can run the code line by line by pressing F8 , and see the code while ruining with the selection data and check if there is any missing data
I think these steps will be more useful for you to get the missing data , not only get the solution but also searching about it yourself and find the error , trying to fix it