I'm building a macro to pull information from multiple worksheets. The source of the data for each sheet is a csv file. I will be building a form where the user can browse and import the csv files. How can I write the VBA to pull File1.csv file into Worksheet1, File2.csv file into Worksheet2, File3.csv into Worksheet3, etc. in a single VBA event? (The names were just examples).
Please include code.