Copying Data from a variable-named workbook

Hello,


I have a macro for an open spreadsheet that prompts a user to select certain other workbooks to open when the macro runs.
The macro takes the selected file and writes the filepath in cell T1 of my main spreadsheet, then writes the actual workbook filename (the .csv part) in cell A4 and opens the selected file. At this point, I want the macro to take all the data from Sheet 1 of the selected file (located in A4) and copy it into Sheet 2 of the original workbook.

Please keep in mind that the filepath/filename will always change depending on what the user chooses at the beginning, so I need the macro to be malleable enough to work with that. Essentially, I want my original workbook to open another workbook based off of the value of cell A4, then copy Sheet 1 from there and enter the values on sheet 2 of my original workbook. I want my main workbook's Sheet 2 to be the same as Sheet 1 of the selected file (file based off value in A4).

Any help would be appreciated, thank you guys for indirectly answering SO many of my excel questions in the past.

Thanks, the code works until it gets to the 'Copy sheet to ThisWorkbook' section. Once that section of code is read, I get "Run-time error '1004': Application-defined or object-defined error."
It could definitely be an error on my end though, any trouble-shooting suggestions?

Did you make any changes to the code I posted?

Did the selected file actually open as a workbook? You should see it open.

I tried it with no changes, and with some changes and still run into the same error. With no changes made, the selected file will open successfully, but will produce the error message afterward (the file stays opened, it just doesn't copy the sheet). HOWEVER, the code works perfectly with a .xls file, just not with a .csv file. What section do I need to change to have it work with a .csv file?

Whoops, just realized the issue. The Main workbook is .xls and the ones I'm trying to import are .csv Any ideas on how to convert the .csv to .xls when it copies over? Sorry about not realizing that, and thank you for your patience and help

PERFECT, Thanks again!!