I have 3 sheets. First sheet has data, consisting of names in left column,
followed by dates.

I want the second and third sheets to have a person's name, and to pull show
only the rows from the first sheet with the person's name in them. I know I
could filter the data in page 1, but i need to have the list on the second
sheet (and third) with the person's name on the tab.

Is there an easy way to do this? I have thought about VLOOKUP, and that
works for one row of data, but not multiple rows.

Thoughts?

Thanks, Patrick