I have excel 2007 and have 47 worksheet which l want to auto sort date in volum A either when opend or closed or as data in inputted. My header is 10 lines. Can some one please help .