Sort data and move to next 5 column
 

Hello
I am entering date wise data into worksheet for every date of data I have
new worksheet now I want to sort all worksheet together as per column €œA€� and
then after all sorted item of column €œA€� has to set next column after sorting
order is change.

For E.g. after sorting A wise when B come it should transfer to next column.
I have 5 field (heading) i.e. when sorting order is change it should copy to
next column i.e. column no. 6

Any help.

****al Shah