Analysis software

Need a utility to analyse large XL files. Requirements are as under We have very large excel files consisting of about 27-30 columns & about 0.5-1million rows. Each file size in the range of about 200MB. These files contain monthly sales data. We need an utility where we can append all these files on a continuous (monthly) basis. On an average 4 such files shall be appended each month. Once these are appended we need to sort / filter data & export the same in small excel files. The sorted/filtered data will not be more than 20-30 MB. Further the data (sorted on one particular type) that is sorted/filtered & exported also will be need to appended in the same (one) file. We will need multiple sorting & filtering options especially multiple filtering options in the utility. Pls. let me know if you can develop such utility. I shall prefer to use the free MYSQL database.