I need to consolidate a certain sheet from a number of different workbooks
into separate sheets on a new 'consolidated' workbook. I have used
DataImport External Data, and for half of them this is working fine.

My problem is that on the other sheets that the data has been imported to
some of the cells are coming up blank when there is data in the original.

Is there any way to fix this? Please help!