Auto-populate from other sheets in a master, than auto total duplicates

I have added trim to remove some spaces, but you need to remove the non numeric numbers in some columns B. The code will not add if the Qty is non-numeric cell. To overcome this error, I have reluctantly added an error trapping line.