Try selecting each sheet first before you get (refresh/requery) the data. Technically you should not need to do this however I have found this to work for me in past.