Sorting Data cleanly that includes Formulas

I have a spread sheet that draws data from one sheet (Raw Data) into a working sheet (From Adobe).
I need to be able to add data at anytime which works well by simply adding names at the bottom of the list in Raw Data. I also need to produce a list sorted either alphabetically (Surname&FirstName) or numerically (Payroll) for reporting. It would be good to have this reproduced on another sheet (Sorting) and not corrupt any other data.
I have tried various things but sorting always leaves hundreds of blank cells at the top of the page or ruins existing formatting.