Is there a way to keep rows together while using the SORT Formula?

I am having excel use the sort formula so it’ll automatically sort anytime a new requirement is added onto a table on another sheet. However, anytime a new requirement is added, the data in the rows (user input) doesn’t get sorted. This causes a mismatch between the user input in the row and the requirement. I looked into just using the sort function instead. However, as the column it would need to be sorted by can include letters, excel is putting those at the bottom of the list.