Regarding Copy data from active worksheet in to another file

Dear Experts,
I have raised a query regarding copy data from one worksheet to another worksheet and it was successfully worked with the help of Dave.
Now I am looking that if i want to do the same in another file, how to do it.
Actually i have made a "Form" file for many users and all files are renamed by users and stored in a same folder.
I want to create a "Log sheet" File and where any user whenever fill the data in the "Form" file, it will copy and paste special value in the next row of previous data.
Is it possible to do?
Or is there any other way to do the same.
Please help about the same.
I am here by attaching the file where macros are working within the file.
I want to move the worksheet as a separate file and if the all users (may be more than 10) fill the data in the "Form" file, it should be coppied in the "Logsheet" file.
The logsheet file will be always open in my system.
Have a look and try to resolve the same