I suppose that I should add that I since I had to chop down the workbook to fit for uploading you won't find the 'H-MC' sheet that I spoke of previously nor any of the information "to the right" of the assembly number and model codes in sheet 'H-DATA'.

None the less, the problem persists even without the additional data.