log and forms (two different files)linked by Macro

[Timl65]

I have two worksheets one is a log the other is a form that is filled out from the information log. The log automaticly assigns a sequencial number when lines are typed for each row. I have made a macro that takes that sequencial number copies it to the form (different excel file) saves the log and closes the log keepiong the form open. But, by using the macro I have to write the a different macro for ever row in the log as when the log fills then the sequencial number increases and changes the row assingment. Understand that the sequencial number is in different rows in the log as your fill the log.
Is there an easier way to do this please help!