Random rows being overwritten on 'data store' workbook after copying from input workbook

Could column E in the pasted in row have a blank cell? That would mean that when the code finds the last row and offsets by 1 to ascertain the next row to past into, it will be looking at the wrong row and overwrite what was there.

BSB