Hello all,
Id like to know if there is a vba code that will combine excel sheets from a workbook in a given folder the data should be consolidated based on headers.

Ex : say i have a folder that has workbooks from 4 different people so a vba code that will ask me to choose a folder which has all workbooks that needs to be consolidated and save it to same folder