Date range creates date-specific outputs into separate cells

[cbjfan2009]

I need to do the following and am not sure of the most efficient pathway:
I have an input cell for start date: (D7). I have an input cell for end date: (D11). This creates my "date range".

I have been using this formula to create a lot code, which is convenient if the lot code is only 1 day:

Please Login or Register  to view this content.

--"Final output" looks like C17MAR2015 S850

Is it possible to tell Excel that I want that formula to output a "final output" for each day of the date range, with each individual lot code in a separate cell?
Sachet Documentation Workbook Example.xlsm
The input cells are on "Print Control", the output cells are on "Pre-Operative Form" in RED lettering. That's how I'd like the output to work. If the date would roll into a new month, the output would need to change to C01APR2015 S107, C02APR2015 S107, etc....
I know there's a way to do this, but my Excel wizardry isn't strong enough, yet.
Thanks a ton. I've been racking my brain for a couple hours trying to make this work!!

[Bernie Deitrick]

I think this will do it....

Sachet Documentation Workbook Example.xlsm