Search and return multiple rows in excel

This is my problem. I have a spreadsheet containing alot of data. What I want to do is create a way that I can search for a recurring name, and return all the information (rows) associated to it. Here is a mini example below:

A    B      C        D          E        F

ID   Name   Date     Client ID  Balance  Owed

100  Tom    1/11/11  256        300      200
100  Tom    1/12/11  565        500      150
100  Tom
200  Jay
200  Jay
300  Frank
100  Tom
100  To开发者_如何学Gom
400  Ted

You get the idea (I hope). So what I want to do on another sheet is search for "Tom" and get it to return ALL instances of Tom in the Name column and return the data in the rows associated to Tom. So I would get back 5 results of Tom with all the necessary information. Thanks in advance!

B

Have you tried Pivot Table option found in the Excel, this might help you without any coding, if all you need is to find some duplicates

Could just apply a filter to the data and have the user select their name from column B. No need to copy data this way, so the update issue goes away. (probably best to delete the blank row below the heading row first)