Copy data from different files into 1 workbook under relevant column heading.

Hi,

I would be having approximately 50 workbooks containing values on different sheets and in different columns. The requirement is that I need to consolidate corresponding values of first column into the main workbook columns.

Also, the files from which data would be copied should go under respective column's heading.

I have attached the files with this post. Please help me as I need it very urgently. Thanks to all in advance who'd reply!

Main workbook name is "Consolidate"
Sample files are "1PS10", "2PS11", "3.PS12" and "4PS13."

PS: It would be great if you can give comments for all crucial lines as I'm novice to VBA programming.

Regards,
Novice