What I ended up doing is to use google script to move the data based on it’s content to the desired sheet.