I am looking at writing a excel roster system .. 8 staff.. assign to job a and tally the hours .. I have one I put together that works .. now would like to improve.

I would like to have a individual job booking sheets that populated the daily roster automatically based on the job date(s).. and uses the data on the data sheet

How could I link the booking sheet to the daily roster so it automatically puts the info into the right daily roster???

Hope the question makes sense and would appreciate advise on how.. or at least how to start

Many thanks