Need help getting data from one worksheet to another based on value of adjacent cell

I have a worksheet that receives a monthly raw data dump from a database. This data is organized by the date stamp from the database but I only get data for days in which data was written to the database. Therefore, if data was entered on September 1st and September 3dr the data dump would only include two rows of data. One row for September 1st and one row for September 3rd. There is not a blank row for September 2nd.

I need to copy this raw data into a formatted worksheet that has a dedicated row for a 31 day month. I need a way to look at the date code of the raw data and use that to copy its associated data to the proper row on the formatted worksheet.

I presume this would require a macro but I am open to whatever solution works. I would like this macro (or whatever solution might work) to run once whenever the data dump occurs. I've attached a small sample workbook with a "RawData" worksheet and a "FormattedData" worksheet for your review.

Your help is much appreciated.

Cheers.

Thanks Special-K! You solution worked perfectly.

Thanks arlu1201 for the VBA version! I don't VBA much so your example was educational for me.

Your guys help has solved my problem.