simple way to create a supplies ordered / inventory SS that is broken down into mini categories

I need to track everything our company purchases in a lot of various categories such as Safety Gear and Supplies (PPE, Apparel, Vehicle Parts and Vehicle Maintenance supplies, Tools, Apparel and promo items, Misc small items, Office supplies, Office tech equipment, Shop tools, Shop Equipment, tools, chemical products, hoses, jetters, nozzles, cameras etc, Job site equipment and supplies (totes, tools, sorbents, etc)

I need to make a inventory count sheet that has the items we purchase and links of where we purchase them for easy reordering and include the previous order dates and quantity's so when we do the next count, we have a running list of what we should have in stock and used and use a blank sheet of the categories when we do the counts.

I was thinking of Breaking it down into Categories, with subcategories or possibly making a table for each various item and then have a master full list that can be printed and wrote on for inventory counts.

I just tried adding a dropdown list in to see if that's the best way but don't want to make it more complex than needed and im horrible at setting the structure up.

what is my best solution and how do i set it up?