to find last number and missing number in series from various sheets

DEAR LEO,

Thanks for the code. My some of the sheet name carries alphabets as well. Code is not working if the sheet name carries alphabet.

Thanks