I have more than one Google sheet, but they all have the same titles. These sheets will be filled by different departments. However, the point where I have a problem is that every information people fill out must appear on the master sheet. I couldn’t figure out how to do this (it didn’t work when I tried what was written). Actually, what is wanted is exactly this. There are 4 different departments and about 8 titles they need to fill. When each department makes an edit to its own sheet, the edit must be transferred to the master sheet. How can I do that.

Thanks for your help in advance.

When each department makes an edit to its own sheet, the edit must be transferred to the master sheet. How can I do that.