Copy rows from one worksheet to another based on date criteria

Hi...i am new to forums but hoping someone can help. I have a workbook for container movements with three worksheets for different product. I regularly update info onto these pages with containers and change the status when arrived and departing . I would like to have it automatically update the Summary sheet with containers that are due within the next seven days to give to the unloaders, however I only want it to copy data from columns C,E,G,H and J as they don't need the other info. Column F & G on the summary sheet would have data manually entered. Hoping you can help and that I have explained myself correctly. I have attached a workbook. Thanks Jo