Thanks protonleah

yes, i have got it solves in another thread.

here is the sample file that i have successfully done it.

just to share to anyone who is going through the same problem.

Combine Success1.xlsm