Return all matching results

I am working on a page that will look for information on several different worksheets to compile as much information about one client onto one page as possible. I used Vlookup for contact information, but am stuck on Contracts and Shipments. Each client has multiples of each and I would like to draw in that information to one place. Basically you would just search for the name of the client and it would return contact information, contracts, and shipments. Is there a way to do this with Excell?