One factor is if the worksheets are xls with formulas used to determine the values for each item/cells criterion.
One way to merge data sets is to create a new worksheet and then assign the data sets from all other worksheets to populate the new worksheet. That works if the data is static, or that it doesn't matter where it appears only that it appears within its respective column space.
It seems as if you are migrating data over to a new system and the old software is not able to export in a manner that can be imported until a new worksheet is made compatible.
However, and in all likelihood, there are formulas in place that were used to determine the values of each cell within the respective worksheets. (If you highlight a header and a formula appears in the formula bar, or that, green hash marks are seen in the worksheet) then the formulas used to equate the value of its respective cell will never merge as first written because the new worksheet is not using the same spaces as the worksheet the data sets are merged from when copying data set A1 to perhaps new data set C1 of the new worksheet.
If the new worksheet is instead a template for the new program, then of course that would be a different matter. Then, you would only need to copy the data sets without the formulas. This could be accomplished by saving the worksheets as a csv or a txt file before exporting those data sets. Then, the data sets would have to be carefully copied and parsed according to the type of data so as not to import data the new program is already programmed to determine.
Last edited by E.Z. Flyer; 29th May 2009 at 10:04.