Search Multiple Workbooks & Copy Between

I have 2 workbooks:

- 1 contains tabs for each day of the month and each tab contains a couple of big tables.

- the other is where I want to gather certain data from the first workbook, selection should be made via a condition. I want to copy not the entire row that meets the criteria but lets say the first 4 cells of the row that meets the criteria (code below still copy's entire row, if you also have the code for my goal I would apreciate it very much).

The next part of code is what i've found on the internet and i'm trying to rebuild it to my situation, the biggest problem is the extarnal link to the 1st workbook sheet it seems to hang there everytime. If I copy a part of the table to a empty sheet in the 2nd workbook just linking to that sheet works so the problem is with the external linking what am I doing wrong?

Sub SearchForString()
Dim LSearchRow As Integer
Dim LCopyToRow As Integer
On Error Goto Err_Execute
LSearchRow = 4
'Start copying data to row 2 in Sheet2 (row counter variable)
LCopyToRow = 2
Sheets("[D:Sudden Death BestandenCHC NetherlandsFuelFuel2007januari.xls]1!").Select
While Len(Range("A" & CStr(LSearchRow)).Value) > 0.........................