Your requirements aren't fully clear to me. If you're lucky a few simple VLOOKUP-formula's and File>Print suffice.

If not, it needs some programming in VBA. It might be worthwhile, however, to consider using MS Access for some or all of the things that need to be done.

Kees