The reference numbers are serialized, and they are just four digit numbers.
i'm completely useless with excell. How exactly would I do this?

Thankyou

"Dave O" wrote:

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.