Fetch weekly data from Access database

Hi guys

I have built an application in Excel as a frontend and Access as a backend. The Access database stores all the data which is present in sheet1 of the attached workbook. I want to generate a weekly report as shown in sheet2 of the attached workbook. When the user selects the "week ending date" from the 3 dropdown boxes(dd,mm,yyyy") then the whole week data should be pulled from the Access database and should be printed off as shown in sheet2 in the attached workbook. The sheet1 is just an example how the Access database stores the data but in actual I am not storing any data in excel spreadsheet as everything gets stores in Access database.

Thanks a lot for any help in advance!!!!