mismatch error when use headers by arabic language

[maghari]

Hi,
the code works well with English headers , but when try to Arabic language then will show mismatch error in this line

b(nRow, 5) = b(nRow, 3) * b(nRow, 4)

so what suppose the code does it in SH1 sheet I would match headers with headers in others sheets and populate data under header and combine duplicates Brand based on column G if contains the same price in column D .
without forgetting add new row before TOTAL row to sum column F .I will add new sheets before SH1 sheet.
I put the result what code should do to understand my problem.
thanks