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.