Rows left out from data source

I have incoming Excel workbooks that I receive monthly. Each workbook gives me one sheet that has columns for, [SKU, SHIP DATE (M/D/Y), and Qantity].  From this data I get how many SKUs are to ship ...