Merging Data from many workbooks in to one workbook

[Excel Fox]

can you post the error description?

Is it by any chance, this..

Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. To move or copy the data to the destination workbook, you can select the data, and then use the Copy and Paste commands to insert it into the sheets of another workbook.

If yes, try using the attached Excel 2007-2010 file.