Copy and paste vba button

Hello,
im aiming to create a button which allow me to input data from the other document. However, the simple "copy and paste" doesnt not work nor the paste special funtion. The data i want to input are table.
When i used "copy and paste", only the VBA code is shown.
When i used "paste special", it gave error message.
What can i do to "Copy and paste" the button?
tHANKS!