You mean have one sheet for the consolidation and then separate sheets per user?

You can even create a userform and select the filters from there, which will appear in one output sheet. If you change the filter, the data in the output sheet is cleared and new data shown.