Sorting data on multiple sheets

Hi,

I'm using Excel to track data from my team for analysis. I have  5 sheets in my workbook one for each week and a monthly overview.

each week totals all data and totals are added to overview using SUM function, however when i sort a column, let's say i sort column a (Name) A-Z, all the data for each person on the monthly report changes. the same happens on the weekly sheets if i change the order of a column everything get mixed up so that each persons stats change. is there a way to stop this from happening? I want to be able to arrange it so that all the data in a row stays the same on each sheet