In my experience, 18-250 is kind of broad to be really good at either extreme, but should be good for most general-purpose work, I would imagine that you can do at least some decent portraiture and macro with it already. Assuming you want dedicated lenses and to stay with the Sony glass, the 50mm f/1.4 should be a decent portraiture lens, and I liked the 50mm f/2.8 macro.
Why don't you post a few shots of what you can do with what you've already got?
Sony has a relatively limited selection of lenses, and I don't use 3rd-party stuff (Tamron & the like), so I can't suggest anything along those lines.