copy and paste the data from two files into one files

[Leonardo1234]

1.xlsm is located in C:\Users\user\Desktop
2.xlsm is located in C:\Users\user\Desktop

i will place the code in third file it is named as book2
see the result in book2 in sheet1

i am attaching all three file plz look into it

 

[Belleke]

Something like that?
open Example (merge) workbook
push button
find Workbook 1 and 2 done
unzip first

 

[Leonardo1234]

Belleke this code is best of best
but i need a code that automatically select the file bcoz i have provided the location of the file and name of the file
So plz look into this once again and do needful

 

[Belleke]

Version number 2

 

[Leonardo1234]

Thnx Belleke for giving ur precious time and great support to this post
Problem Solved