gmayor thanks a lot - your boiler template is a huge collection of batch process. I want to use your vba macro found, for selecting 8 files (sample) :

Sub YaddaMultiLine()Dim myFiles() As String
Dim myFilesListed As String
Dim j As Long
Dim var

With Application.FileDialog(msoFileDialogFilePicker)
    .AllowMultiSelect = True
    .ButtonName = "OK"
    .Title = "Select Parent Folder"
    If .Show = 0 Then Exit Sub
      If .SelectedItems.Count > 1 Then
         For var = 1 To .SelectedItems.Count
            ReDim Preserve myFiles(j)
            myFiles(j) = .SelectedItems(var)
            j = j + 1
         Next
      Else
         myFiles(0) = .SelectedItems(1)
      End If
If j <> 9 Then
   MsgBox "HEY!!!  You are supposed to select 8 files." & _
      vbCrLf & "Macro will terminate.  Try again."
   Exit Sub
End If
End With
If j = 0 Then
   myFilesListed = myFiles(0)
Else
   For var = 0 To UBound(myFiles())
      myFilesListed = myFilesListed & myFiles(var) & _
            vbCrLf
   Next
End If
MsgBox myFilesListed
 End Sub
Instead of asking the user to select files from displaying the files list in a directory, I want to store the selected files from his input and merge only those documents. Here is the screenshot of my simple user form.

sample screen.jpg
Pl help.