Copy complete sheet in excel with condition of a word

i want to copy a complete sheet in excel,
but only the data with specific word in one of the columns.
for example :
number name rate
1 dan 90
2 dan 100
3 tal 60
4 dan 30
5 roy 50
6 dan 100

copy entire sheet if the name "dan" in column "name".
result :
number name rate
1 dan 90
2 dan 100
4 dan 30
6 dan 100