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.

May I suggest removing any blank columns in your data. I could cause problems with sorting and lookups.

Unfortunately due to the variety of training for staff and the need to seperate these into seperate columns, I cannot completely eliminate all blank columns. I could ensure all have a heading, but there will often be no further data below these. I managed to formulate a basic pivot table to sort the names alphabetically and reduce blank cells to one. I was partially ably to use this information to lookup data from the "From Adobe" tab yet not as cleanly as I would like, and not all data I require was able to be displayed this way.

I was hoping I could copy the data and last just the data without formulas, then remove totally blank rows before sorting.

Thanks. I have been trying without success to achieve what i want to do to re-order the list cleanly. I am resigning myself to enabling a filter on the page and narrowing down lists as I need them and making sure not to save the file with these changes. Thanks for the input.