I have 3 sheets. Here is the formula.
=SUM(InventoryOrdered!D23:CA23)-COUNTIF(InventorySold!B:B,"10-414500")
This is on sheet InventoryInStock

When I add another object I want to be able to sort them AtoZ and then for
the cell ex:D23:CA23 to change appropriately. When I add an object I add it
to InventoryOrdered and InventoryInStock that way the sheets are the same.
What do I do? Also, I need laymans terms and step by step instructions. I
have had no "training" in Excel and figuring this out as I go. Thank you
ahead of time for your help.

God Bless,
Harley