If all your input files are formatted the same with predictable "cells" (row, col) then you could possible use a script I've written to take input from several Excel spreadsheets and put it into a single one by rows - much like what you're describing. I've adapted it to allow for tab-delimited and CSV input files.

Have a look at: Parse Excel Spreadsheets To Single.