Hi there

Could anybody possibly help me tidy up my data by advising how I can re-order my columns?
I have a worksheet which contains data on the companies. So in column A is a list of company names, and in Columns B, C, D etc are single Data values for each month of each year.

The title headings are taken directly from a folder, so are saved 'july-13.xls' 'jun-14.xls' etc. and im looking for a macro to put them in order so that the earliest date appears in column B, through to the latest date in column 'x' or whatever it may be. Each month, another column will be added as another file gets added to the folder.
The end aim is to be able to look at how the data values have progressed over time, and then potentially make a graph from these. So if anybody has another way to get to this end product via macro that would awesome too.
Could anybody be on any help? I have no idea how to do this, and searching forums has proved useless.

Thank you in advance! Any feedback would be much appreciated!


Millie