I have one workbook (inventory workbook sheet1) that pulls the information off of another workbook (data workbook sheet 1). If I try to insert a new row in the middle of the data workbook, let's say A10, the formula on the inventory workbook that pulls the data over is now skipping over A9. I have tried just using = and indexing to pull the data. Is there anything that will update the inventory sheet without skip a row? I hope this is a new question and makes sense.

Thanks,
Todd