Extract Information from on file to another with Power_BI or formulas?

Hello everyone,

My problem as the description states is I have several excel files (45) each with 1200 to 1600 rows, and I need to extract some information from them and put that into one file. In my attached file the top table (Table1_example) will have 1200 plus rows, and the second table (Table2_example) is where I want to consolidate all of the information in that row based on if column AB has any information in it.

Would this be easier to do with MACROS or by using a formula? I appreciate the help and I'm glad this site exists because it would take me months to figure out the best way to extract this information. Please let me know if there are any questions.

Moderator if this is in the wrong section I apologize!

Update:

Here is a little more information.

I have managed to place the files in a specific location (folder) on our network, and each file has 19 tabs. The current tab that I am trying to extract the information from is on tab 12. I hope this information will help. Again, thank you in advance for your help.

BB4523

Are the tab names with the data the same in each file? I would use Power Query for this.

No, you would use the query from Folder option. It will prompt you to select one file as a sample to set up the processing you want done on each one, then it will apply that to all the workbooks in the folder and return the results as one table. There are numerous walkthroughs on the web (eg this one: https://support.microsoft.com/en-us/...8-6a00041c90e4)

Thank you for the suggestion. I will review the link you sent and try to muddle through it, I'm not the most experience at formulas or using queries. Thank you again.

Update:

That is a lot of information to work with, but I managed to get all 33 workbooks loaded or at least started. I'm having trouble getting to where I can combine all of the tabs.