Create a summary sheet

Ok, I have created a workbook at work. It contains lots of worksheets within it, each worksheet being a seperate job number.

So what I would like to do is, create one worksheet that has a "live" summary of each job.
So, if needs be, I just open up this workbook, go to my 'Summary' page and I can quickly look at the status of the job from there. So.. I have the exact idea of what I want, I know that every job number (worksheet) has to feed into this one paticular worksheet (Summary).

So for example, if I was to go to job number 3 and changed its status to 'complete', this would then change it automatically on the summary sheet!

I know it's quite complicated, especially when I already have macros and everything in which I have created (this is for when I open a new job, I press my shortcut keys and it automatically opens a worksheet and completes all the form formatting for me.)

If anyone has any suggestions (in layman's terms! ) please reply to this post.
I'd be very happy to hear any suggestion what-so-ever!!

Thanks!

P.S. Please see attachment to see my rough draft diagram