Runtime Error 9 Subscript out of range. Run Macro from workbook1 & Pull &Save date from other Workbook2 onto workbook1

This is Probably an easy fix but i’m not seeing what mistake is.