I have a macro to filtering data from two or more sheets in the result sheet, I hope this macro will useful for you.
And I hope someone want revised this macro become simplest macro script.

Thanks you.
Naris