pulling data from master sheet based on date and time (shedule/diary)

[AkaTrouble]

hiya

have been asked to make a schedule diary type work book for a friend

so far i have created a userform for entering data appointments etc to a worksheet called "MasterData" (will show example below)

i need to produce a Day / Week / Month sheet that populates from this source data

i have not done any layout for these pages as yet so can't offer any samples but to describe end user request

could i put a date on day sheet and see all entries against the time in column 15 minute intervals

on the weekly sheet could i see 7 equal boxes one for each day that shows first 5 or 6 entries for that day

on the monthly sheet have the days show like a calendar with 5 lines for each date displayed

my thoughts are to create a fixed layout for each and enter a day Week end or month which then populates each (seperate each sheet not dependant on another)

i am guessing Vlookup or index and match but don't know where to start as day will need to be against time as well as date and there will be more than one result for each date (just thought i will put error check in userform to confirm no duplicate time and date entries)

below simplified MasterData sheet

Any help or ideas Gratefully Recieved ... Thanks for reading and hope makes sense

regards Trubs

DATE TIME DESCRIPTION VALUE 27/03/2017 12:00 Lunch £20.00 28/03/2017 12:00 Lunch £20.00 29/03/2017 12:00 Lunch £20.00 30/03/2017 12:00 Lunch £20.00 31/03/2017 12:00 Lunch £20.00 01/04/2017 12:00 Lunch £20.00 02/04/2017 12:00 Lunch £20.00 27/03/2017 13:00 work 28/03/2017 13:00 work 29/03/2017 13:00 work 30/03/2017 13:00 work 31/03/2017 13:00 work 01/04/2017 13:00 work 02/04/2017 13:00 work <colgroup><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>