Consolidate multiple workbooks data in an order from folder

I have a macro that consolidates data from multiple files in a folder to a workbook. But the problem is the files are named after months and while consolidating the data are not pasted in order. Say if there are 3 files named July,August and September in the folder. The data are copied in the file names ascending order (eg., August,July,September) but i need the data in the order - July,August,September.

Please help me with the code.

Please Login or Register  to view this content.

This might help: http://www.thesmallman.com/excel-custom-sort-with-vba/