Dear Emadmina ,
Kindly check the BOQ referenced items for each building type before to combined all sheets , i think there are some shift rows in the main BOQ before to combined it into one sheet , so this error appears
Kindly , check this before run the combined BOQ |Macro and send the excel sheet again after checking