Linking & Updating Sheets

[ExcelnoviceUK]

Hello,

I was hoping someone will be able to help me.

I set up products for a company and we have an ever growing amount that I have to manage and set up.

See attached 2 spread sheets:

Spread sheet 1 (individual products) - This is a list of jobs that my team are responsible for. I have to manage each member of my team and go into each product spread sheet and initial / date when they have completed the jobs they are responsible for. This is so I know exactly that we have covered everything.

Spread sheet 2 (All products) - This is an overview of all the products listed individually with the job numbers across the top. Currently I look up what stage my staff are at with there jobs and I update my overview. The more and more products we are launching the harder this is becoming for myself to manage.

Is there any way that when I update the "individual product" spread sheets that the initials or a tick could automatically fill out in my "overview" spread sheet?

I hope this makes sense.

Many thanks.

[ExcelnoviceUK]

Hello,

Can anybody help me on the above problem?

Many thanks.