ok.
I'll try to do my best explaining the process.
Let's say I have 2 Files.
First file=Names.xls
Second file=Orders.xls

Each file include one sheet.

the name of the sheet in names.xls is: "First"
the name of the sheet in orders.xls is: "Second"

The "names.xls" file is open,while the "Orders.xls" is closed.

I would like to run the vba from the names.xls , which means I want to open the orders.xls file and copy all the data from the "First" worksheet(except the header row).
Then, I would like to switch again to the names.xls file, and paste all the data I just copied, to the First empty row in names.xls, in "second" worksheet.

I Hope It's clear now.I tried my best
Thanks again.