How to create automated planning sheet.

Hi Experts,

I need help in automating a production planning sheet, that has different phase of production. I have different production phases in different sheets in one workbook i.e Material Check, Paint Shop, Assembling etc, which are already in a pre defined template format. My challenge is - production phase is different for different product, so I need help in developing a macro which create the 'Final Planning' sheet basis given input.
File attached

Thanks in anticipation
Rajesh

Attachment 322