sheets overview with filter function


Dear Expert,

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!