Copy data from worksheet to worksheet then sort

[ipbr21054]

Morning.
In my workbook i have two worksheets.
On my worksheet "HONDA SHEET" data is entered into certain cells.
These cells are arranged A-Z
Like so,
ACCORD ID48
CRV ID46
JAZZ ID8E
STREAM ID8E

In the other worksheet "INFO" the same data is shown but currently in order of smallest to largest so i can see which items are selling better than others,this is sorted from a macro button on "HONDA SHEET"
Like so,
JAZZ ID 8E 37
ACCORD ID48 20
CRV ID46 4
STREAM ID8E 1

This is my goal for today.
As data is entered into the cells on "HONDA SHEET" automatically update them on "INFO" sheet.

I will have a macro button on "HONDA SHEET" which will take me to the "INFO" sheet BUT show me the items from smallest to largest.

Please can you advise me some pointers.
Im lost as to how the cells are updated from one sheet to the other because each time i use the macro button the "INFO SHEET" cell data will be constantly moving there location and showing me the selling popularity of sold items.

Example
If cell AV4 is ACCORD ID48 but then i sell a few of them and now its new location is cell AV1, how does the code that updates the "INFO" sheet know to now update the ACCORD ID48 in cell AV1 and not AV4 ??

Where i mention macro button it will just be press button then take me to the page in question,the main bit is files be updated & arranged each time.

Sub LEADERBOARD()'
' LeaderBoard Macro
'


'
    Sheets("INFO").Select
    Range("AV1").Select
        ActiveWorkbook.Worksheets("INFO").AutoFilter.Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("INFO").AutoFilter.Sort.SortFields.Add Key:=Range( _
        "AW1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
        xlSortTextAsNumbers
    With ActiveWorkbook.Worksheets("INFO").AutoFilter.Sort
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
        End With
End Sub

Please advise.

 

[ipbr21054]

My answer is this.

Can you help this way then please.

Lets say i just need to see the current popularity situation on the INFO sheet

On a macro button press we could collect the data from the HONDA SHEET & put it into the INFO table & sort it A-Z

This work around will be fine for me.

Thanks very much.