I’ve most often seen this error, @azbob27, when a required data-source column is missing from a worksheet in the destination workbook. You can see the same error in this thread.
You may need to figure out which column is expected. I’d consider unhiding the hidden area to the right which may offer clues.