sheets overview with filter function
I have 3 sheets filled out by external partners ( same columns set up). They add rows and change the cell status.
Based on the 3 sheets, I would like to create one sheet with all the content on it for our headquarter overview.
I tried a Report which works, but I don't have a filter function here, to create a personal view.
Is there another better way to combine the 3 sheets in one and use filters?
Thanks for your help!