How to have multiple sheets automatically populate master sheet as data comes in

Question

I am trying to have multiple sheets populate into one master sheet in google sheets. I have figured out how to populate multiple sheets from the master sheet using the =filter() function. However I am unable to figure out how to do it the other way around. Essentially I am trying to track call bookings for our team and am using an external program to automatically populate cells when calls are booked. I have a "master sheet" with all the calls booked for the team, then individual sheets to track calls booked by each rep. I have it so the external program populates the master sheet and then the filter function populates the personal rep sheets automatically, but I cant figure out how to do it the other way around (have multiple individual sheets populate the master sheet automatically as the individual sheets get populated). Is this possible? And if so how do I do it?

Answer 1

The setup you describe exposes you to the risk of formula results getting misaligned with manually entered data. See Lance's explanation of the row misalignment issue.

One solution is to not use multiple tabs, but have everyone edit the master sheet directly. Use filter views in the master sheet to let multiple simultaneous users sort, filter and edit the data without disturbing each other.

For additional ease of use, you can insert links in the frozen section of the sheet to easily switch between filter views, instead of having to go to Data > Filter views to switch. See the Filter views example spreadsheet for an illustration.