VBA code for consolidating multiple workbooks

[Rohith1324]

Hi All,

Could you some please help me with the VBA code which consolidates multiple spreadsheets data in one spreadsheet

I have 4 spreadsheet.( Column headers are same across )

I have 1 seperate spreadsheet in same folder where with the help of VBA Code it should consolidates all the data in this sheet.

Data in each sheet will be on higher side.

Regards,
Rohith M