Copying the contents from one sheet to another sheet which is in different folder

[HB07]

Hi.
I am working on one excel file which has got some macros running. I want to copy the contents of one File into another file which is in different folder. Parameters folder contain one "master file" in which the contents are to be pasted. Metrics folder contains the "Metrics Module" file whose contents are to be copied and pasted. In "Master File" there is one sheet called "Dashboard" where one command button is placed. I want to execute the macro with this command button.
I tried several things but they were not working
Please help me out.
Thanks in advance for the help

[Leith Ross]

Hello HB07,

It is not clear to me what is to be copied. Do you want the data from the table Master Failure List worksheet to be copied to A1 of the Dashboard worksheet?

[HB07]

Hello HB07,

It is not clear to me what is to be copied. Do you want the data from the table Master Failure List worksheet to be copied to A1 of the Dashboard worksheet?

Hello Leith,
I want the data in column A of the "Master Failure List" worksheet to be copied in the column A of "Sheet1" of the "Master File" when user clicks the command button "Copy Data" from the Dashboard worksheet. I hope I am clear. Please let me know if you could not understand the process flow.
Thanks Leith in advance