Summarizing input from multiple sheets and sorting in filter.

[xe-dingo]

Hi

I feel I might be going about this all wrong, but I am trying to collect information from multiple sheets in to one summary sheet (see attachment).
The workbook is to be used by multiple users so I am trying to make it as simple as possible.
The problem is, that when a user adds rows within the input sheets, these rows do not appear on the summary sheet where the summary filter is located. I have in addition, added code to refresh the filter when sheet is selected.

I think I might be going about this all wrong, and that VBA is the way to go, but in both regards, I still am not able to get it to work.

This sheet is just a simplification of my issue.
My real spreadsheet has 16 sheets and a lot more information on them. But the essence is that I would like the information from rows in the input sheets can be collected and filtered according to users specifications in a summary sheet.

For instance showing rows only done by "Tom", or sorting by date, etc.

Any help MUCH appreciated. I've been struggling with this one for a while.

[p24leclerc]

Have you ever looked at PIVOT TABLE? It's a great tool and very versatile. You just have to rearrange your data to be in one sheet. See attached workbook.