Why the fixed limit of 22 entries on SHEET2 when SHEET1 does not appear that it would have the same limit ?

Is it imperative the number order of column F be as in your EXAMPLE sheet or would an A->Z order be acceptable ?