I have a spreadsheet for each of the 3 small stores I own. One part of each simply calculates the frequency with which each item in store sells. I want to compare these sales indices so have a consolidated spreadsheet in to which I = the calculated indices. Trouble is each time I sort the the three store spreadsheets, the consolidated one messes up. Any advice please?