AMAZING! You absolutely nailed it. This is the sheet I've been working on and want to apply those formulas to, https://docs.google.com/spreadsheets/d/1VHyg1mi5Eyb7IiN2SiE-EiPdsnSbQmwxQ7kEZnB1Joc/edit?usp=sharing

Is there any way to apply a similar formula to the "orders" tab, so it would automatically add a new line (at the next available empty row) on "inventory"? I say the next available empty row because I have a lot of entries I need to manually enter without adding orders for it right now. It would be need to copy the upc, item, cost per item and qty. Ideally it would only copy it over after the Received box is checked.

Seriously can't thank you enough for your help!