Are the reference numbers serialized, as in 2071, 2072, 2073, etc?

If they are, you might create 10 or 20 copies of the same tab within
the spreadsheet, and then set copy 2 to add 1 to copy 1's reference
number, and repeat for successive sheets.

A lot depends on the format of the reference numbers.