Copying data from a master worksheet to a folder full of closed workbooks

Hi Guys
I am fairly new to VBA and am trying to create a workbook that copies data from a master worksheet to a specific worksheet in a folder full of closed workbooks when I click a button. I am using the code in the attached notepad file to do this but I keep having an application or object defined error on this particular line,

Please Login or Register  to view this content.

. I am not sure what I have done wrong but I can bet it comes from my lack of understanding of VBA and understanding how the commands work. I would love any help anyone can give me on this. BTW I had to put the code in the attachment as it was setting off a sucuri firewall thing that probably protects against dodgy code or something but I have no idea what in my code would be setting it off and I could not post it any other way



VBA Test Code.txt

Thanks for that Kaper
That seems to work although something strange is happening when I run the command. I go to open my sheets that have been altered and they wont open although in my windows preview pane I can see that the data has changed. Is there something preventing them opening when they are changed? I tried restarting my computer and clearing excel process and even opening them in excel safe mode but nothing seems to work. Thank you so much for your help
Unit Sheets Original code.xlsmUnit Sheets New Code.xlsmTest Sheets 01.xlsx