Question: how do i import data from multiple workbooks into one?
Answer: Go to the Data tab., In the Get & Transform group, click on the New Query drop down., Hover your cursor on 'From File' and click on 'From Folder'.