Have a separate workbook for each day with only a single worksheet in it? I'm assuming that these amounts are never edited, otherwise the active sheet would naturally be the one "on top" (which is the one that Adagio will import).

Why not just copy batches if the amounts aren't changing?

If the cheque amounts are always the same, why not import invoices with approriate dates and then do a system check run to select the ones to pay?

I guess I'm missing something about the reason they are doing what they do.