This sounds pretty standard to me. Spreadsheet stacks are actually effective - and often robust if the Copy Paste technician has a little bit of nous. I don't think it makes sense to get the individual involved in trouble, but it isn't intellectually honest to pretend this is that strange or unreasonable. Offices are full of people who make things work in inefficient ways. Such is life. Improve the system if it fails, but there isn't any call to act surprised that the process is awkward.
I expect there is a lot of politics at play here.