Find column heading then sort the sheet off that column

I'm trying to create a macro to find the column heading "NUMBER" then sorting the entire spreadsheet from using the NUMBER column. i've tried recording it but sometimes the report will have a different amount of columns and rows, so If anyone can help that would be great