Manufacturing Inventory reduction formula

Hello,

I work in an electronics board manufacturing lab. For many years inventory was not kept current, and parts shortages were common.

Using a previous excel inventory list (10 years old), I've updated the many thousands of individual parts counts.

Now with inventory correct, I need to write a formula removing the parts from inventory as I build cards. Meaning if I build a single board (or numerous cards), I need it to remove five parts from box 21E (or E21?), plus 20 parts from box 59E, 2 parts from box 308E and so on. For each card entered into the formula box.

There are up to a total of 90 parts that go into a card in some cases. So entering reduction numbers for each part is tedious and time consuming. In some cases taking as long as the build itself.

I've done serious hunting on the net. Finding mostly over complicated, often unneeded featured like profit margin, forecasts etc...

I only need it to remove what I use based on the number I build (enter).

Thanks

P.S. I have not written Excel function since Windows 3 So, I've lost most of that schooling. So, I'll need a template/example I can work with/build up.