.
You can start by Googling "Excel Workbook Inventory Management" ... or something similar. That will provide you with example projects others have already completed. Select one design that comes close to what you
envision using in your environment. From there ... volunteers on this and other forums can begin to assist you.
You can even search this forum for examples that have been posted in the past.