Sort Part of a List

This was certainly important to take care of, and I'd love to solve it. Also, thanks for the help. But I just copy pasted the data and re-formatted it seemingly EXACTLY the same, and the issue didn't follow the worksheet. Same book and everything.

To sum up, when trying to sort any part of the table, the entire table would auto-select and any sorting done to any column would apply to the whole table. To make my sort work, I had to sort by column B, then sort part of the results by column A. Not sure what was locking it into auto-expand to the whole area, but a new sheet fixed that. If anybody has an idea it would be great for the future, but for now a new sheet works.