Auto Sorting based upon 3 columns? (Mac 2004)

Hello all,

I am a pretty big n00b when it comes to Excel, so bear with me here. I am on Mac OS X, and we are running Office 2004.

I work for a magazine publisher, and need to keep track of who we charge when they send in an ad wrong. Basically, I have a workbook with 4 sheets. Each one is basically the same thing, just with different categories (Decor, Industrial, Salon, Food 360) -- but still need to be auto sorted and updated dynamically. Column A is the name of the publication, column B is the issue date, column C is the name of the advertiser, and there are 5 more columns that are also in the sheets that I don't need sorted.

What I have filled in each is just fake info and just to get things working.

What I want done, is basically an automatic version of what happens when I hit "Sort": I have made a macro of this, and figured I could automatically have the macro run any time I add/change a new row/info. This macro looks like this:

Sub AutoSort()
'
' AutoSort Macro
' Auto Sorts columns
'
' Keyboard Shortcut: Option+Cmd+s
'
    Range("A5:H35").Select
    Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Key2:=Range("B5") _
        , Order2:=xlAscending, Key3:=Range("C5"), Order3:=xlAscending, Header:= _
        xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

My questions is, how do I do this so that each sheet, when adding a new row of info, will dynamically and automatically sort alphabetically/numerically like that "Sort" macro?
Hope this makes sense! It's been driving me nuts!!!

Thanks in advance,
Josh

Well, I figured it out... This only took about 4-1/2 hours... LOL! I used this code on each Worksheet in the VBR editor:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A5:C35")) Is Nothing Then
        Range("A5:H35").Sort Key1:=Range("A5"), Order1:=xlAscending, Key2:=Range("B5") _
        , Order2:=xlAscending, Key3:=Range("C5"), Order3:=xlAscending, Header:= _
        xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    End If
End Sub

And with this Macro:

Sub AutoSort()
'
' AutoSort Macro
' Auto sorts based on the first 3 columns.
'
' Keyboard Shortcut: Option+Cmd+s
'
    Range("A5:H35").Select
    Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Key2:=Range("B5") _
        , Order2:=xlAscending, Key3:=Range("C5"), Order3:=xlAscending, Header:= _
        xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

This seems to work, and it now autosorts dynamically based upon mainly the first column (publication name), followed by the second column (date), then the third column (advertiser name).

Hopefully this can help any others in the future.