PivotTable
 

I'm using a pivot table to bring information from a spreadsheet over to my spreadsheet when some adds data to it. The problem is when I try to sort Column A the other columns that aren't in the pivot don't stay with the right row. It only sorts Column A and not the other columns that are suppose to be included in the sort. Anyone? Thanks!