I appreciate your effort, and I am familiar with index/match, but the linked files will be used for other employees to a link to my workbook. I am trying to create a situation where all they have to do is hit refresh all and they will see all the changes to the inventory. The index/match will not show new data unless they manually drag the formula down which I dont think is a reliable option. The fiel I attached was just a snapshot of the entire workbook, our real workbook contains 35,000+ line items and grows daily.