Consolidating data from multiple excel workbooks into one

Hi I have data from A7 to AG with a varied amount of rows and I want to know how I can select data from multiple excel files and bring them into one. Thanks for the help.

Hey cheeseleweese,

Power Query (now called Get & Transform) is the tool you need to learn and use for this problem.
https://www.myexcelonline.com/blog/c...g-power-query/

Another way is to learn VBA and write code but the above is much easier.