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.
Ok, I have a .xls file with a list of nearly 2000 items. I would like to buy/build a program that will search for a name that I enter and retrieve values from a cell in the same row, different column, then add those columns to a bank and print a report with the searched name and value retrieved. Has anyone heard of anything like that?