Attached is a very basic example that I put together. I have left some instructions within the workbook. I also put your macro into the workbook to test it. It worked great, but needs to be repeated for the rest of the dates.
Thanks again!
Example Workbook.xlsm
Bookmarks