Several Daily Excel Files into one using VB

Question

OK, So Ive got several Excel files that come into a folder each day. For example, Ill have 08-26-2010-1.xls, 08-26-2010-2.xls, etc. Each file has the exact same formatting structure, etc. I need to take those daily files and then stitch them together in a Vb console app. Can someone please help put me into the right direction? Ive found scripts where it takes several worksheets within Excel and binds them but not actualy files, espically daily ones.

ANY help would be grateful.

Thanks

Also- This is part of the code that I have for copying over the files, they are xml, so for each xml there is an excel file. Perhaps the following could be modified to create one file and have all the files dump into it?

For Each file As String In todaysfiles ' Excel stuff... '

        Dim fileName As String = IO.Path.GetFileNameWithoutExtension(file)

        ' Concatenate full path. Extension will be automatically added by Excel. ' 
        Dim fullTargetPath = IO.Path.Combine(targetfolder, fileName)

        'Process each file in SourceFolder
        ' For Each file In fs.GetFolder(SourceFolder).files
        'Open file in SourceFolder
        xlWkb = xlApp.Workbooks.Open(file)
        'Get Filename
        BaseName = fs.getbasename(file)
        'Concatenate full path. Extension will be automatically added by Excel
        fullTargetPath = targetfolder & "\" & BaseName
        'Save as XLS file into TargetFolder
        xlWkb.SaveAs(fullTargetPath, xlNormal)
        'Close the file after its done
        xlWkb.close()
    Next

    xlWkb = Nothing
    xlApp = Nothing
    fs = Nothing