Date in Consolidated sheet does not match date in sheets being consolidated

New to the forum, I have an XL 2010 sheet (attached). The date field in the tabs are consistent and display correctly. My consolidated sheet however shows the dates incorrectly. I have highlighted the data in the sheets and the consolidated sheet where the dates are different. With my basic setup I was hoping to consolidate my data as shown then I would sort that by date for analyzing. Sinse the dates in the consolidated sheet do not match the original data, I'm at a loss . Help would be greatly appreciated.

Thank you very much, you have explained why the date changes and you are corrrect in that I am using "sum". Now I understand what is happening, BUT, if I use "min" or "max" as suggested, the date is correct BUT the data for the calls is not a "sum".(which I need) Is there a possible solution to my sheet that allows the data to be "sum" and the date to be correct. (ie: the last date entered for that call.) all showing up on my consolidated sheet.

Your solution is workable and I am playing with it. I don't want to mark my issue as solved in case there is further input. As far as Low teck, I can assure you that I am in over my head but I do like to play in deep water.

Update: Your solution is VERY workable and in fact has solved my issue. I played with the table a bit to hide columns not required and I have set it up on my "live" sheets. Thanks for your help, very creative and effective solution.