My sub code works fine. But if I turn it into function, it fails. Can I
use a function to get a result from another sheet?

What I am doing is to put the function in sheet1, then the function
will activate sheet2 where it filters a table and get a sum of a column

Thank you