Can you post one of the workbooks you are trying to get data from?