1) Select wbs to be consolidated
2) Both have headers... where? - the very first row is considered as header
In every sheet? - Yes
If the header is not present then it is created? - Yes
Based on headers what data needs to be added up? Column data of respective header

[Please refer to the attachment once may be it will provide more clarity]

3) After selecting files a folder is created where? The folder from where the files to be consolidated are chosen
Consolidate what sheets into what workbook sheet? All Sheets across all the workboks to one Final workbook with one sheet
I'm guessing U mean collect the data from some sheet(s) in some workbook and placing the data in a sheet in some other workbook? - yes even this need can arise but i believe we can modify the code to choose specific sheets (if needed)
4) Save the workbook in the consolidated folder. What is the wb/file name and what is the folder name and address. What if the folder exists? What if the file exists - i guess i have mentioned that the file would be named Consolidated* (in order to avoid duplicacy datr / time stamp can be added)
Are U going to be attempting to provide any code? I have bits n pieces of codes that i can share but honestly im new to vba and not that skilled at it.

That being said im not shying to learn eithr