This short explains how can you filter the data and get it copied automatically to another sheet using advanced filter inside power query.