Copy data from one workbook in a range to another workbook

Hi everyone,

I am trying to write a VB code that allows me to paste data from a selected range on a sheet to another sheet in a seperate workbook by clicking a button.
I was able to write the following with success from one sheet (Broker 1) to the next (master) within the same workbook. Is there a way for me to modify the existing working form to paste the data into an external workbook e.g: C:/folder name/master.xls, sheet named "master" saved in the same folder?

Sub Button208_Click()
Dim NR As Long
Dim wsCF As Worksheet
Dim wsMA As Worksheet

Set wsCF = Sheets("Broker 1")
Set wsMA = Sheets("Master")
NR = wsMA.Range("A" & Rows.Count).End(xlUp).Row + 1

wsCF.Range("T5:AE5").Copy
wsMA.Range("A" & NR).PasteSpecial xlPasteValues

End Sub

But is there a way to open the workbook and paste the data?
E.g:

Sheets("Broker 1").Range("T5:AE5").Copy
Workbooks.Open ("C:/folder name/master.xls")
Sheets("Master").Activate

Thanks I will try that.. I also encountered another problem.. I have 156 sheets each with an object button on it which allows the user to transfer data to the 'master' each sheet has a different name. Is there is a way for me to reference all the sheets instead of creating a macro for each button on every sheet?