Using a MACRO to sort data

Is there a way to use a Macro in an Excel Workbook that would allow me to
sort multiple sets of data on multiple sheets at one time?

P.S. I have never created a Macro before.