Thank you all for the suggestions. I really appreciate it.
So far though, I am leaning towards the use of a Pivot Table first and then filling in blanks. Here is my issue:
Say for Item Number "DEF" there is no "Planned Demand" (just for arguments sake), then that row isn't going to show up, but I still need it represented as Zero's in the final format. So taking a direct pivot and copying and pasting into the final format will only go so far.
So then my program would need to look at the "Order Type" field for every "Item Number" and make sure that every item number has all order types. Does this make sense?
I have been working on just directly looking at the Item Number, Family and Order Type and copying to the first sheet. Below is the code that I have so far (taken from some help Watersev gave me on another problem). Still tweaking it a lot, but just showing what I am doing so far.
Bookmarks