Macro

I have lot of data which need to be analyzes and sort according to various criteria and the data is and analyzes data is to be presented on different sheet, please provide some help