Excel spreadsheet stopped pulling data half way through spreadsheet

Good morning

I've created an inventory program through excel, where I have the master inventory sheet, incoming sheet and outgoing sheet.  My main inventory sheet has stopped pulling quantity data from my incoming sheet around line 482 and stopped pulling quantity data around 299 from my outgoing sheet?  All other data it pulls from both sheets perfectly fine? 

I'm using =SUMIF(OUTGOING,CONCATENATE(A482,"O"),QTYOUTGOING) for pulling data from outgoing sheet

I'm using =SUMIF(INCOMING,CONCATENATE(A299,"I"),QTYINCOMING) for pulling data from incoming sheet