Merge Macro not working as espected

[cpugach]

Hi EveryOne,
I'm having an issue in my xls file.
Have 3 sheets,
local, global, and the first one is to merge thoose two, and create two files.
The issue is in the merge button, when i press it, it creates the two files, but not completly.
It should have the nunmber of opportunity records (wich is working fine) and a separated sheet called Global, or Local.
The Local file is working good, but the "Global" created file, doesn't have the "Global".
Can you please help me?
Thanks.

I Share this document for you.

https://drive.google.com/open?id=0BzWCSGWONIXNS2duTXVYRFBpUVU

 

[cpugach]

ADding a new link on mega.
sry.

[FONT=source_sans_proregular]https://mega.nz/#!qAREwChT[/FONT]