Driving a task list from different worksheets

Hi,

Quite a new Excel user (using 2003). Only really done very basic stuff but realise its capabilities are much more than i know so have signed up to a mid level course which starts next week.

In the meantime I have a problem which I would like to resolve. Have done a couple of hours of research including searches and I think the solution is dynamic lists but nothing I've tried works!

The concept is simple. I have a number of projects which I work on which I map out on a worksheet as attached but what I would like to have is a Summary sheet which pulls in the tasks that I should be working on from each Project Worksheet on any given week.

Can anyone point me in the right direction?

Cheers,

Guy