This code will continually ask for new raw files until you hit cancel. It will record the contents of columns N,O,P,Q,R,S,T,U,V into column G (and then H etc for subsequent raw files).
Sub trimalakumar()

Dim FileToOpen As String
Dim MasterFile As String
Dim RawFile As String
Dim myLookup As String
Dim myIndex As Variant
Dim i As Integer
Dim j As Integer

FileToOpen = Application.GetOpenFilename("All files (*.*), *.*", , "Select Master File")
If FileToOpen = "False" Then Exit Sub
Workbooks.Open FileToOpen
MasterFile = ActiveWorkbook.Name

FileToOpen = Application.GetOpenFilename("All files (*.*), *.*", , "Select Raw File")
j = 0
While FileToOpen <> "False"
Workbooks.Open FileToOpen
RawFile = ActiveWorkbook.Name

i = 2
myLookup = Workbooks(MasterFile).Worksheets(1).Cells(i, 6)
While myLookup <> ""
Debug.Print myLookup

On Error Resume Next
Err.Clear
myIndex = Application.Match(CInt(myLookup), Workbooks(RawFile).Worksheets(1).Range("F:F"), False)
If Err.Number = 0 Then
''''''''''''''''''''''''''''''''
' Value was found. Grab your raw data and store it somewhere
''''''''''''''''''''''''''''''''
Workbooks(MasterFile).Worksheets(1).Cells(i, 7 + j) = Workbooks(RawFile).Worksheets(1).Cells(myIndex, 14) & _
Workbooks(RawFile).Worksheets(1).Cells(myIndex, 14) & _
Workbooks(RawFile).Worksheets(1).Cells(myIndex, 15) & _
Workbooks(RawFile).Worksheets(1).Cells(myIndex, 16) & _
Workbooks(RawFile).Worksheets(1).Cells(myIndex, 17) & _
Workbooks(RawFile).Worksheets(1).Cells(myIndex, 18) & _
Workbooks(RawFile).Worksheets(1).Cells(myIndex, 19) & _
Workbooks(RawFile).Worksheets(1).Cells(myIndex, 20) & _
Workbooks(RawFile).Worksheets(1).Cells(myIndex, 21)
Else
''''''''''''''''''''''''''''''''
' Value was not found. Error code goes here.
''''''''''''''''''''''''''''''''
End If
i = i + 1
myLookup = Workbooks(MasterFile).Worksheets(1).Cells(i, 6)
Wend

Workbooks(RawFile).Close
j = j + 1
FileToOpen = Application.GetOpenFilename("All files (*.*), *.*", , "Select Raw File")
Wend

Workbooks(MasterFile).Close

End Sub