Excel Macro

I need an Excel 2007 macro, it needs to be able to compile information from standard text files into a format as per the finished example I've uploaded. The text files are .LDT which is a file format for lighting software. I need to be able to compare up to 50 files side by side in one worksheet. I could do this manually via cut and paste, but life is too short.

Any questions drop me a line, I've uploaded my standard xlsx file of examples if you want to experiment.