Creating a staff rota

Hi everyone

Im new to excel and this forum so go easy on me

Im looking to improve my staff time table so that:
-when i enter a work shift into sheet 1 it automatically appears in sheet 2 as a 'time bar'
-I've added some screen shots to show the sort of effect i'm looking for

I really need to get this working as my current planning with pen and paper is a nightmare! any help or advice would be appreciated!

Thanks

Danny