Expressions/ pulling data

New to the expressions and AppSheet. I will try to explain what I am trying to do. I am trying to take multiple set datas on one tab on google sheets and mirror it into another tab in a different template. However I am trying to get the data to populate in the right spot based off date, product ID, Category ID, and total amount sprayed on a given date with a specific paint. If that makes sense. The images show the format I have for the app and another tab showing with a different style template. I plan on creating the app for the employees for basic use and a cover page more organized data sheet to be shown to the business owner