copy same positioned row of all sheets in one workbook and paste accordingly in another workbook

[Tet Htut Naing]

Dear All,

I am trying to write a macro and cannot start. I want to copy the same position rows of all sheets in a workbook and paste them in the last rows of sheets in another workbook. Here, sheets' names of those two workbooks are the same. I am trying to save the records of resigned staff (NGO).
In details, in the first sheet of the first workbook, I will select a row and run the macro, then it will copy all the same position rows of all sheets of that workbook, and paste all the copied rows at the last rows of all sheets in the second workbook.

If it is possible, please help me on this.

Best Regards,
Ko Htut

 

[My Aswer Is This]

I do not understand what:

"The result is the same"

means.

I have tested this script five times and it works for me.

Maybe someone else here at Mr. Excel can help you.

I have to leave for now and will not be back till tomorrow.

 

[Tet Htut Naing]

Thanks
I do appologize for leaving not saying anything.
I will test your code tomorrow and update the results.
Best
Ko Htut