I have a worksheet that contains a team of people's names of in column
A that I would like to find in another worksheet lets say an employee
timesheet worksheet.
Let's say the first workhsheet is called "TEAM A" and contains the
names Amy, Ben, Carl, David, Earl.
The other worksheet "Employee Timesheet" contains the entire list of
employees that were working on a given day which may or may not include
the people in "TEAM A" worksheet.

I want to write a macro that would allow a user to do search for all
the values in "TEAM A" that appear in appear in the "Employee
Timesheet" worksheet and then take the row with the employees name
(which would also include the time worked) and add that to a range that
I can paste into a user specified destination.

I need to know how to do the search in the "Employee Timesheet"
worksheet based on the people in "Team A" worksheet.