Help needed to fetch data bewteen "XYZ" from multiple files located on one location

Ahh, I see. I thought your problem was that the empy cell was getting skipped. I see now that the cell with embedded commas is being interpreted as more than one cell.

Sorry I don’t know how to fix that.

Maybe regenerate the source file and use something other than commas as a separator within the field.