Question: how to import multiple text files into excel on one worksheet vba?
Answer: Hold down the ALT + F11 keys in Excel to open the Microsoft Visual Basic for Applications window.
Click Insert > Module, and paste the following code in the Module Window.