Stock, inventory and new items control

I need to create formulas that interconect one page with the other, I have 3 pages, shipped, stock, New. I need that when I ship item 1-A, the stock updates it, item 1 can be 1-A 1-B 1-C, I need that the formula be precise on that