Might be neat to use a Bayesian classifier to guess which existing column the data should be merged into. Use the column names as labels, and train on the data already in the main sheet. See Algorithm::NaiveBayes for a generic Perl implementation and this node for a short example of how to use it.