Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.
Would it be possible to make it a little bit more flexible,
For example, I will paste all the worksheets into folders that are the same headers , by selecting the file path & selecting the run macro file it should get consolidated into single file