I think you have specified the exact problem and solution yourself. As I
see it, there is not enough consistency in the workbooks, or email  names
being received. Whilst it is possible to code for these exceptions, it
would be much easier to just enforce a common standard onto your data
supply group.

Things like different starting  points in workbooks, or different sheet
names should not be allowable.