Copy/past and 18 line jump

I am novice in VBA and I fight a little to arrive has to make what I want:

Here is the situation:
A Sheet " Result ": I have a name of equipment and the rest of the information has to fill with other tabs
Information is of the " old ", " current ,"date change, "...

Example of tab "Source":
I want to copy the information in corresponding compartment has the equipement in the resultat sheet. The 1st line of information goes to a line and the following one owes positionner18 lines more low may begin again the action to has the line 329 of the sheet "Source"
I have just make the action of copy:

Please Login or Register  to view this content.

Now I wish to repeat this action to source has the line 329 of the tab and by jumping 18 lines has every time in the result sheet.
What is what somebody can depanner me?

Thank you in advance,
Best Regards,

Do you have a sample file that you can attach?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

You do not have to attach your original file. Just a mock up will do with the same format as the original.