YOu have almost successfully created a database! If you are new to VBA, then you would pick up access just as fast, and would get a better product for what you have described! EXCEl is for calculations and such, not data entry and record keeping.
Build some tables (if you need help, just ask!)
Build a form that is mapped to the table (the form will automatically input the data into a blank "ROW"! Magic!
Build reports based on what you need back out!
It is that simple, and easier than learning how to code, as there is no code besdies SQL! Which BTW is an actual code, and pretty robust on a massive machine like an IBM with BI!