I'm trying to filter a list following to fulfill a few criteria. Although I
could use Advanced filter but however i couldn't filter it to another sheet
in the same workbook. Any other suggestion how I could do it so that data
could be automatically updated from the first sheet, if it change?

I couldn't seems to be able to use microsoft queries in the same workbook too.

please advice.

Thanks