Copy data from a workbook to another workbook using Macro

[[Felipe]]

Hi guys! I need some help to create a Macro that copies data from a spreadsheet to another spreadsheet... The destination workbook contains information in the columns B to P, and the workbook that contains the information to be copied contains information in the columns B to P too.

How can i do this with a Macro and a button?

PS: I want to put the origin spreadsheet always in the same place, like C:\Programs... Thatway, the Macro needs to open the path and the archive, copies the information and paste in the other spreadsheet.

I apologize for the bad English, haha.

Already, thank.

[KT99]

Do you want data from multiple sheets to paste into one sheet? Or do you need data from one sheet to copy into a new sheet?

[[Felipe]]

Its a dashboard and every day i need to copy information from one sheet and paste in a plan of this dashboard using a button like "UPDATE".

[KT99]

Are both sheets in the same workbook?

[[Felipe]]

No, the sheets are in different workbooks.