Excel 2007 : connection two workbooks

Hello guys,

I correctly making production report form, this form consist two completely different workbooks, first workbook where I planning to put my production data and second workbook where my final version of production reports.

Basically I need to connect those workbook, when I was put data into first I want automatically transfer to second workbook some of them (not all data) ,first workbook contains some columns which have two different data separated with “/”,those cells I want to show separately in my second workbook. I will try being more clear with colored cell.

Thanks guys in advance.