Drop down box with 4 coloured results

[ma.tt]

Hello all, I'm Matt, a newbie here. New job requires me to use a lot of Excel, so this may shortly become my new home!

Sorry to the mods if this is in the wrong section, I'm starting to panic over my problem and am getting desperate for answers.

I have basically found a restaurant tracker online and am in the process of editing to suit my needs. I now realise I am nowhere near as clued up as I thought I was.

I am looking to add a drop box with a reservation type into the first worksheet. The types will be 'Festive 2/3, Festive Sharer, Normal Sharer and Normal Menu'. This will then export the second worksheet as an overview of bookings for the day. I want each booking type to have its own colour.

Also a bit of a long shot but I'd like the info on the 1st worksheet to export to the 3rd sheet but separate into Weeks 1 Bookings, Week 2 Bookings, etc etc up until Week 4.

Can anyone help me out here? Point me to some tutorials or anything. I'm suppose to have this up and running by Monday and I'm starting to flap, haha. This may be more work than I expect so any help is welcomed.

Can potentially pay a small fee if needed. (Not letting me upload here so I have elsewhere.)

Please see attached.

Tracker.zip

Thanks,
Matt.

[protonLeah]

title updated 10/09

[ma.tt]

Sorry about that mate, It wouldn't let me attach before as the file size was too big. Think I've met all the above criteria.

Anyone?

Thanks.

[protonLeah]

Part one:
Not sure what you want. On sheet bookings, I used data validation drop down in column E. Then applied conditional formatting for rows A - K based on the value in E.
Same idea on sheet pre-order based on value in column C.