I have a small service business with a parts inventory of approximately 180
items. A typical business day involves the sale of 3 or 4 inventory items
and the associated installation labor. Purchases of replacement inventory
occur 3 or 4 times per month.

I am trying to build a sales worksheet and a purchases worksheet that would
automatically update the inventory worksheets. Can someone suggest how I can
accomplish this? Or, if there is a better way to go about this, please point
me in the right direction!