Save a sorting rule

Hi,
I need to sort a set of cells repeatedly using a sorting rule that has multiple levels (e.g., sort on date from largest to smallest, then sort on sales total from largest to smallest, then sort on years with the company from largest to smallest etc.) It takes a while to set up the sorting rule each time.
I currently use Data ribbon, then Sort icon on that ribbon.

Is there a way to save a sorting rule like that and then reuse it?

Many thanks!
Studiosa.

Dom,
Thank you very much. I am not up to VBA, I am afraid. Still learning the basics.

Studiosa

Dear Dom,
Thank you very much for your previous answer. It took me a while to get the time and the courage to forge into macros/VBA. I finally launched myself into this area of Excel.

As per your suggestion, I recorded the macro. Actually, I recorded two versions of the macro. The first version("sort_macro_w_clear_filter") starts by eliminating all filtering from the table of data, then sorts the table. The second version ("sort_macro_no_clear_filter") does not have the step of clearing the filter, but just goes straight to sorting. If the table happens to be filtered before I run the macro, "sort_macro_no_clear_filter" does not do the right job (because it "does not see" the hidden rows of the table).

The main difference between these 2 macros is that the "correct" macro has this line:
ActiveSheet.ShowAllData
But the incorrect macro does not have this line.

The problem is that the "correct" version of the macro ("sort_macro_w_clear_filter") sometimes produces and error. Of course, now that I am writing the message, I cannot reproduce the error. But it seemed to happen some of the time (not all of the time) when I filtered the table before running the macro.
I am not sure whether this gives you enough information to tell me why I have this "occasional failure". Are these specific known conditions that cause ActiveSheet.ShowAllData
to fail?

I attached an example of what I was working on.

Studiosa.