VBA to search for multiple values in one sheet then copy to another sheet

Hi there
Here’s the issue:

I have three sheets….
Sheet1 has the Data
Sheet 2 is blank
Sheet3 has the search Names {there are about 100 rows with name values}

I want to search Sheet1 for all occurrences of where the name values from Sheet3 might occur, and then copy them to Sheet2.
I have no idea where to start because I need the search to loop to search for the next name value from Sheet3.

I have attached an example of the workbook layout; however there is no code.
I know how to do a basic search and copy code, but I am unsure how this will work when the search value is held in 100+ rows on Sheet3.

Here’s a little sample of what I am trying to do…….


SHEET 1: (has many rows of data i need to search through)
SHEET 2: (is currently blank, and is where the output from the search will go)
SHEET 3: (has Coloum "A' filled with rows of names like DLPTPAYR or DLSYCNTY. These are table names, and I am searching a script from SHEET1 to see if these table names from SHEET3 appear on SHEET1 then copy them to SHEET2.