Linking two sheets in different workbooks takes a long time even with only 500 rows of data. Is there a quicker, more efficient way to do this?

[chazrab]

As stated. All I'm doing is highlighting and copying only 500 rows of data across 10 columns of an address book, which is in two different workbooks.
When the source userform is changed /updated, the other should update automatically because of the link. It's not instantaneous. I have to save the destination
file, close the destination workbook reopen it to see the updated changes. Very inefficient and slow. Am I doing something wrong and not uderstadning
linking capabilities correctly? The simple code for the source workbook is:

Private Sub PutData()
Dim ws As Worksheet, l As Long
Set ws = Worksheets("NEW")
With ws
ws.Cells(Me.Row, 1).Value = TextBox3.Text
ws.Cells(Me.Row, 2).Value = TextBox8.Text
ws.Cells(Me.Row, 3).Value = TextBox9.Text
ws.Cells(Me.Row, 4).Value = TextBox2.Text
ws.Cells(Me.Row, 5).Value = TextBox1.Text
ws.Cells(Me.Row, 6).Value = TextBox4.Text
ws.Cells(Me.Row, 7).Value = TextBox5.Text
ws.Cells(Me.Row, 8).Value = TextBox6.Text
ws.Cells(Me.Row, 9).Value = TextBox7.Text
ws.Cells(Me.Row, 10).Value = TextBox10.Text
ws.Cells(Me.Row, 11).Value = TextBox11.Text
ws.Cells(Me.Row, 13).Value = Website2.Text
ws.Cells(Me.Row, 14).Value = Itemfield.Text
ws.Cells(Me.Row, 15).Value = NDEBIGVIEWMOREINFO.TextBox2.Text
DisableSave
End With
End Sub

PutData just adds and saves changes to the Source sheet which is named NEW. For clarity, the source and destination userform is the image below
Thanks for anyone's help.
cr