Excel Address Sorting Task

I’m working with two Excel workbooks that each hold a column of street addresses followed by three companion columns—Names, Phone numbers, and Email addresses. What I need is straightforward: every address must be grouped and ordered strictly by street number, lowest to highest, while keeping those other information columns perfectly aligned with their original rows.

Primary and secondary sorting are both by street number, so there’s no need to juggle postal codes or other fields; consistency is the goal. When you return the files, I expect:
• A clean, fully-sorted version of each original sheet (or one consolidated workbook with two sorted tabs, if that’s easier for you).
• No data dropped, duplicated, or shifted—Names, Phone numbers, and Email addresses andnall other info should still match the addresses they came with.