Copy sheet to another workbook

Copper Contributor

For ms office 365, how I can auto copy one sheet data to another workbook ?

I am a manager. I have shared a workbook having multiple sheets to my colleagues. They update it daily. One of the sheet data i want to be auto copy in my masterfile when updated the shared workbook. How can I do it ?

3 Replies


You could try using a VBA macro or a Power Query to automate the process of copying the data from the shared workbook to your master file. You could also try using the Move or Copy Sheet command to manually copy the sheet from the shared workbook to your master file.


**Which of these options can/may/should be used depends on your digital environment (Excel version, operating system, storage medium, etc.) and partly also on the other users.


Hope I was able to help you with this info…if not please ignore the message.



I know I don't know anything (Socrates)

move or copy says my workbook isprotected

@Don Bleeker 

You must unlock the file if it has a password.

Change or remove workbook passwords