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.