Hi people,

I am looking for a solution on how to collect data from selected tabs and info. Statement as below.

1. I have total of 10 tabs, in which I only want to gather data from 5 tabs, into country tabs.
2. Each of the 5 tabs, I want to filter by a section (ie by country).
3. Copy the whole row to this new 'overall' tab.
4. Data will always be live, meaning there maybe additional rows every now and then

Initially thought of query function, but only manage to get it done for 1 tab and not multiple tabs. Unless if there is a macro like function in google sheets?

The purpose of this is so that 'Overall' tab can only be viewed(with certain limitations) by a certain people, without overwriting the 5 tabs.

Any help is much appreciated!