Inventory handling

We have products that will be ordered over several months and will be scheduled to ship sometime within a 15 week period.  ie. I may order in December to have my products shipped in May. 

I am looking for some help to develop an inventory handling report that can be easily managed by exporting data from PC for each week of shipping throughout the 15 weeks or pulling data from my MS SQL database sorted by shipping week into an existing excel spreadsheet.  Another option is to create a spreadsheet that will have a macro to fetch the info from the exported file. I will use the spreadsheet to keep track of inventory in/out and QOH throughout the 15 weeks.  I am manually entering the sales data now from the PC Sales Reports for each date range which takes too much time and is easy to make mistakes with the data entry.

Anybody have any ideas about how to either modify PC to export CSV data to this spreadsheet or build a separate report in another program by pulling info from the database.  If you have a good easy solution, let me know.  I am willing to pay for the programming to make this work.

The custom data export will only send information about products sorthed by when they are ordered but not by when they are scheduled to be shipping, again, we may not ship for several months. 

Stone edge is not really for me, tried that already.  More trouble than it is worth.

The XML integration may be worth checking into...

We have modified the Sales Report by Product to include the expected shipping date range but I cannot export it as a CSV file like some of the other reports, it is only html.  Can that be fixed easily?