Can you Filter using names from a generated list???

[Scott]

I have a macro that takes a list of peoples names from my data sheet, then
pastes them to a separate sheet and only leaves those names that appear 3
times or more. I would then like to use this list of names and go back to the
original data sheet and filter by each name one by one. For example, if John
Smith's name remains on my generated list, is there a way to plug his name in
to the filter for the original data set?? The list of names generated is in
column A of a sheet named "Employee Names" and the original data appears on a
sheet entitled "Data" with the names in column H.

 

[Scott]

When the list is filtered by that individuals name I am going to copy all the
data for that person and paste it on a new worksheet. Then I am going to the
next name and the next and doing the same for each.