Combine Workbooks based on their name

[Rahulwork]

I have an excel, in A1 i have a folder path, which will have folder path

in folder there are 4 excel files

- sample full
- sample partial
- example partial
- example full

i want when i click on button , macro should go to A1 path and combine all files has prefix sample. combine means merge on one single sheet.

same with example files too. please help

 

[alansidman]

Maybe Append via Power Query

Append vs. Merge in Power BI and Power Query - RADACAD

Combining two queries in Power Query or in Power BI is one of the most basic and also essential tasks that you would need to do in most of data preparation scenarios. There are two types of combining queries; Merge, and Append. Database developers easily understand the difference, but the...

radacad.com

Combine Data from Multiple Workbooks in Excel (using Power Query)

Power Query can be of great help when you want to combine data from multiple workbooks into one single worksheet. Here is a step-by-step guide on how to do this in Excel. You can combine data when it's stored in an Excel table, or even when it's not formatted as a table.

trumpexcel.com

 

[Rahulwork]

Thank you so much for your response. can we done this via VBA?