Can't entirely picture what you mean from your description, but my guess for an answer would be ....
Forget Excel/Word etc..... you'll end up with lots of nasty macros.
What you need is a nice simple to use database....try FileMaker (
filemaker.co.uk)