Solutions for Equipment Hire system

Hello

I need to find a solution to a problem. I work for a equipment hire company, where various computers and structure are hired out on different jobs. We are getting to a point where keeping track of stock is a problem, we need to quickly be able to check if an item is already booked on an upcoming job, and keep track of home many are in stock. ETC. Keeping in mind that I have some excel knowledge (with a little bit of macro). Could you either point me in the right direction to get this done using Excel, or suggested some pre made software I could use instead.

Any help would be greatly appreciated.