Autosort by date AFTER formulas are updated

I have an excel report that is generated in another program every week. The report is not sorted by date and it may have 100 rows of data one week and 200 rows of data another week. My excel file has formulas that refer to this original report. I need those formulas to update first, then I need the information to automatically sort by date (column D in my excel file). I have tried to setup a script to run, but it's not working. I will attach the file and the script.

Sorry I'm new to this so I apologize in advance if the pasting doesn't look right...

Please Login or Register  to view this content.

Thanks!
Nate

And yes, I do need to sort by date AND the item # (forgot to mention it in my post, but it's probably obvious if you look at the script or macro in the file)...