Excel sorting help

I've used Excel's help feature and am assuming their is no easier way to set this up, but does anyone know an easy way to automatically sort data throughout an entire Excel sheet after you make changes to a single cell. I need to sort the same data across multiple sheets by different columns(hopefully someone understands what I just said.) I have a macro written that does it but would like to know if there was an easier way.