Macro that finds word in table and reports all rows with data to new table

I am still learning VBA and dont really understand what you are saying. I have simplified what I am looking for a bit. Everything is now in one spreadsheet and no need for a macro to create sheets. Here is an update. Please help if you can.

_I. Sheet1 - 949 rows of data - Is a list of unique files
___A. Row 1 - column titles
___B. Row 2-949 - data being reviewed
___C. Column A - contains file names (ex. vsd.html) of next software publish
___D. Column B - Contains overview notes on each file
___E. Column C - contains detailed notes on each file
_II. Sheet2 - 804 rows of data - Is a list of files that may appear on multiple rows
___A. Row 1 - column titles
___B. Row 2-804 - data being reviewed
___C. Column A - contains file names (ex. vsd.html) of customized files
___D. Column B - contains version number
___E. Coulmn C - contains notes for version changes
III. Sheet 3 - Where output should go
____A. Row 1 - column titles
____B. Column A - will display data from Sheet 1, column A
____C. Column B - will display data from Sheet 1, column B
____D. Column C - will display data from Sheet 1, column C
____E. Column D - will display data from Sheet 2, column A
____F. Column E - will display data from Sheet 2, column B
____G. Column F - will display data from Sheet 2, column C
_IV. Goals
____A. create macro that runs the following.
_______1. selects Sheet1, A2 and searches for a match on Sheet2, Range A2:804.
_______2. if a match is found it copies range A2:C:2 to sheet 3, Range A2:C2
_______3. it then copies the matching rows data in columns A, B, & C and copies it to sheet 3, Range D2:F2
_______4. it continues to search through sheet 2Range A2:804 since there may be mutiple instances of the file being searched since sheet 2 lists all versions of the file. If multiple versions are found it copies the same data on each next row down on sheet 3.
____B. make macro loop.
_______1. once search of sheet 1, A2 is done it goes to the next line down and searches for that file and repeats the same steps
_______2. continues this until it has searched for all 948 rows on sheet 1.
____C. End result should be a new list that details all the files that will be affected by the next publish that have been customized