So I am working on an assignment for work, and what I am trying to do with excel is something i've never done before. i work for a contracting company (constructioN). I am now in charge of all tools and equipment within my company. There are hundreds, almost thousands of units that my company owns. I need to create a spreadsheet that can help me track all these items.

My company has around 50-80 projects going on at any given time. With 6-8 superintendants, running anywhere from 1-10 jobs each, we are starting to lose track of our equipment. When a piece of equipment is needed, the superintendant of the job will come to me and tell me what he needs, and i will need to be able to tell him if one of the other superintendants has the tool, or if it is in our warehouse, or if we need to buy another because all other tools are being used.

Basically, what i need to create is similar to the type of software that any rental company would have. like blockbuster video, for example.

I want to have a tab that has the company's total pool of equipment, showing ALL equipment with ALL quantities. Then maybe on a different tab, or further down that page, i want to have drop down boxes where i can assign a quantity to a particular superintendant. When i assign a piece of equipment to person, i want it to automatically take that qty. out of the company's pool qty. Could someone explain to me how this can be done, or at least point me in the right direction? I don't even know what to look up as far as tutorials for this situation. Help would be much appreciated