copy and paste data from one sheet to another using vba

Hi all,

Hope you all doin good..well am new to this forum as well as VBA.I have a 30+ seperate excel files in one folder.The sheets contains data for a single month for 30+ projets.I want to pull the data into new master file using excel macro.Im trying to create macro .What i need is


1.The 30+ sheets are different projects which contains its own datas.
2.I need to put one master/Consolidated sheet which has a macro to collect the data by an single click for every month.
3.The Master sheet which should update automatically based on the different project sheet colum name.


Need your assistance to complete this activity.


I have attached my sample sheets here...

Thanks in advance people.