Thirty spreadsheets. One output. Done by hand, every two weeks.
Someone opens each file, finds the rows that matter, pulls the numbers, and pastes them into the master sheet. Then checks their work. The output is identical every cycle. The only thing that changes is which cells moved since last time. The person doing it has it memorized. That is the problem.