From the spec you have given, I would strongly recommend using a relational
database such as MS Access, rather than Excel. It would probably be possible
in Access but it will be a pain to create and ten times worse to maintain.