Macro only works in one spot. Need macro to work on multiple cols and tabs and files.

I am frustratingly (if that's a word) trying to learn about macros. The various tutorial pages I've found online give good directions on how to create a macro which I have done and the macro works, but I have not found out how to make it work on different columns on the same spreadsheet or on different spreadsheets (tabs) or even different Excel files.

My task is to select three columns, sort by the first col and then by the second col, and end with the cursor at the top of col1. I created a macro to do that, which I *think* I stored in MyPersonalWorkbook. The macro works, but ONLY on the first three columns over and over. The files I am working with are a large series of three-column data sets (colA,colB,colC are for set1, colsD,E,F are for set2, etc.). Each file has about 10 tabs of this type of data, and I have several files per week to deal with. So, having a macro is very appealing because I would have to manually sort every 3 cols for a HUGE amount of data on multiple tabs within multiple files, every week.

What I want is this.... Sort a set of three columns by the first and then the second col in the series of three, then end with the cursor at the top. Bult I want to have this macro available (via a button or whatever) to sort the next three columns, then the next three, and so on. I want it available to then move to the next tab on the same workbook and do the same. Lastly, I need it to be available for use in the same manner for an entirely different Excel file. Note that all sortable areas on all tabs and workbooks are the exact same size and shape (3col X 32rows).

I am using Excel 2010. My thanks to anyone that can help me figure this out!

Answers to your questions:

1. yes, but there are multiple sets of three columns per sheet, but they all start on the same row and are all of the same size. I need to sort every set of three columns. (sort areas would all begin on row3 of colA, colD, colG, etc. across the sheet on any tab.)
2. no blanks anywhere within the three columns to be sorted
3. no blanks anywhere within the three columns to be sorted

Although the sets of three columns to be sorted are moving across (to the right) on each sheet, all sets are a consistent 3cols X 32rows with no blanks. To simplify things, I am attaching a way cut down version of one of my workbook files. It has three tabs, all of which have three sets of three columns. Each set is already ranked (first column) by the data (third column) but sometimes there are rank ties, so I want to sort by firstcolumn (rank) and secondcolumn (name) in each set to make the ties sort alphabetically. The third column will take care of itself once the sort is made.

Please note that on the first tab only, I have given an example of what I need as the final result (cols N-V). What I need is a macro I can click on to:
1) select the desired data range (in my sample file, the first range would be A4:C18) and sort by colA then colB.
2) then I would like to be able to move my cursor to the top left cell in the next set and click the macro button to sort the next range (D4:F18)
3) then same for the range G4:I18.
4) THEN....I want to move to tabs 2 and 3 to do the same sorts on the data sets there.

I hope that all makes sense. Please let me know if you need more information. Basically, I need to create a macro that will sort a standard size data range anywhere on any file, by the first then second column in the range. A macro that would allow me to sort each set with just one click on a button would save me untold time as the sample I'm attaching is probably only 1% of the size of the data sets I am dealing with. As an additional benefit...I have avoided macros for years but I'm beginning to see what a time saver they are so I really need to learn more about them.
Thank you very much for your reply and help with this.