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.