Macro Excel for GlobalSheet

[draconagi]

I need to make a macro in Excel which can recover the global sheet of a test.
he will copy the globalsheet in a new sheet in my worksheet excel.

how can i access to the global sheet to get the data and make what i need ?

Thanks a lot.

[Ankesh]

please correct me if i am wrong.

Do you need to copy the content of test globalsheet to a excel file?

[draconagi]

Yes with a macro
i got the link to the test and i need to concentrate all the globalsheet of my test into one excel file.