Excel 2007 : Will autofilter work?

Hello,
I've been working on data sorting for the past month or so and have finally decided to look up excel macros to make my life easier.
The situation I'm working with is to copy whatever values that we had sales for that day into another workbook depending on the first column value.

Files:
December 19- December 25 This is the format im working with.

28 This is an example of the work that i input into the formatted sheet.

Thank you.