I am using a pivot table to control a list that needs to be updated
frequently and feeds into a complex series of workbooks. Each individual adds
their own data in colums adjacent to a copy of the pivot table located on
their own spreadsheet. When the pivot table is updated and sorted, the sheet
where individuals are adding data updates with the new row headings, but only
the headings sort leaving the related data in the wrong rows. Is there any
better way to do this?