Excel Query Problems, Not Getting All Data

[murphy00]

I have a macro getting info from another workbook from columns A thru D. On some sheets the query will return all of the data. On others it will not return data from column B. I have checked the source workbook that is being queried and it does have data that it is not getting.

Anyone have any ideas on how to fix this?

 

[murphy00]

The column the data will not come from contains Room numbers. I have found that it will return anything that looks like text. If the data is a number it will not return it. Example: it will return 33/16 but won't return 100.
I have formatted the source column as general and have tried text. Neither work.