Copy/paste Range of worksheets of several files in a folder to a master file

Hi,
I have several folders with 8-10 files in each folder.
Each file has 14 sheets in them. I want to be able to copy the range (A5:G16) in sheets named Daily to a new file called master. So the Daily sheets range A5:G16 of each file get cpoied vertically in the master file.

I asked this question in Mr.Excel and got the following code. The code must be ok because when I hit F5, while VBA is open, it takes me to the right directory. However, when I created a form control button, it gives me an error message, "can not run the macro 'Import.xlsm!Button1_Ckick'.
So, I am thinking my processes are wrong. I would appreciate it if you could check out the code and provide a step by step of how I should implement this code.
What I did was to put the code in a module, save it, creat a button.
Thanks

Please Login or Register  to view this content.

• Right-click on your Form control button
• Select Assign Macro from the pop-up context menu
• Select your tgr macro
• OK