Sheet A in file X to Sheet B in file Y when both files are opened by excel.

Is there a way we can copy whole content of Sheet A in an already opened .csv (which contains sheetA) to an empty Sheet B in another already opened .csv (which contains sheetB) by macro?

Thanks a lot!