Looking for a vlookup VBA code vs a page transfer

[Excelnoub]

I need to copy and paste information from one page to another but I need also that this information to be on the same row of my Column's A information.

Ex:
If sheet1 Cell A5's information = Test and the following code is added:

Please Login or Register  to view this content.

I need the

Please Login or Register  to view this content.

to be copied on the same row in "report" sheet on the same row where information "Test" is.

This code will copy and paste it to the next available row.


Help

[Excelnoub]

Example of the transfer:

Sheet “MERX”
A5 = Test
E5, F5 and G5 = Dates
If I5 has “yes” then Copy A5 to next sheet
Else
Copy E5, F5 and G5 then paste but lookup for “Test” in Column A in Sheet “Report” then paste E5, F5 and G5 to F*G*H*

Sheet “Report”

A5 = Run test
A6 = Tryout
A7 = Test… E5, F5 and G5 from sheet “MERX” will be copied to F7,G7 and H7.

[Excelnoub]

Here is my Excel book if you need an example.

In Tab "MERX" you will see 3 example. On the "Report" Tab you will see the results.

Test003.xls