Since Lookup is a table calculation, it relies on data in the sheet it is used on. As such, these types of hide filters cannot be used across multiple sheets.
Can you describe in more detail what you are trying to accomplish? Is there some sort of aggregation you are trying to achieve by hiding these values instead of just filtering them? If so, it may be possible to achieve something with LOD calculations.