Is it possible to have a long list over many worksheets as follows;

Worksheet1 -Monday
Job Code Data1 Data2 Data3
Bob 101 8 5 12
Bob 940 12 1 3
Dale 101 2 4 7
Bob 101 1 3 2

Worksheet2 -Tuesday
Job Code Data1 Data2 Data3
Tim 101 8 3 4
Bob 145 4 9 2
Tim 101 4 1 3
Bob 101 5 2 8

Etc...
This data changes day to day by the way.

I would like this data to simplify to a unique list including Job & Code as
criteria. The above would simplify to:

Worksheet3 -print week
Job Code
Bob 101
Bob 940
Dale 101
Tim 101
Bob 145

This would then be put onto another worksheet (print week) in the form above.

Is this possible to do this so that if you change the data in the worksheets
-Monday and Tuesday the Worksheet3 -print week automatically & dynamically
changes also?

Note that the list in Worksheet -print week would get smaller or longer
depending on the data in Worksheets -monday and tuesday. Also note that
there are 40+ names and 10+ codes.

Thanks.

Howard Leung