excel filter not working on new rows

For example if you want to return the copied visible rows only in the existing working sheet G1 is the starting cell after auto f…