Macro to open multiple files with changing names

[KeithMale]

Hello,
I am trying to make a macro to open a series of .csv files and copy data into the active workbook. The names of the files are different each time, with a common suffix.
An example file name would be "SPW2292-11-(A-B-C)-G_I13_C1_002-w-vFine-X-Top" where "SPW2292-11-(A-B-C)-G_I13_" will change each time.

Is there a way to open files with just the last section of the name?

Here is what I have now that will open the first file:

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this (not tested).

Please Login or Register  to view this content.

[KeithMale]

Thanks, that seems much easier to follow, but I am still getting an error (Run-time error 1004) that says the file cannot be found.
The files are in separate folders than the excel file that the macro is in, so it looks like I need to add a way for the wbSource to find the SourceFile in the correct folder?

How would I add that in the Loop?

[AlphaFrog]

Sorry I missed that. Try this...

Please Login or Register  to view this content.

[KeithMale]

Sorry I missed that. Try this...

Don't worry, I accidentally left that out.
Thanks a lot for the help!