I don't know what the spreadsheet looks like, but it sounds a pain!  We tag at birth now so avoids the problem, but I used to use spreadsheets I had made based on the paper books you could get from the Scottish Government, where births would be recorded on the holding register, and then there was a separate 'ecord of first identification' sheet for tagging.  Doesn't really help you, though.