I have created a monthly time sheet for my employees to fill out. Since they
can work on different projects during the days of the month, the spreadsheet
looks like this:

                            M          A           R             C          
H
                   1          2         3         4          5         6  
........... 30          31
Project A      2.5                  1.5      1.0                  3.5        
   1.5
Project B      3.0       4.5                 3.5                  2.0        
   3.5         4.5
Project C      1.5                  2.5                  6.0                
    2.5         3.5
Project D                 3.0                 2.5                  1.5      
                  1.0
.....

What I would like to see is the worksheets that follow the master
spreadsheet to be populated as follows:

    Project A
1           2.5
3           1.5
4           1.0
6           3.5
......
30         1.5

    Project B
1           3.0
2           4.5
4           3.5
6           2.0
......
30         3.5
31         4.5

    Project C
1           1.5
3           2.5
5           6.0
......
30         2.5
31         3.5

   Project D
2           3.0
4           2.5
6           1.5
......
31         1.0

etc. for the number of projects on the master spreadsheet, and each project
on a separate worksheet.

Is this a VBA project, or can it be done using worksheet functions?

TIA
David