Sales report from sales data sheet if i select the date

Please help

I WANTED TO GET THE DATA FROM DATA SHEET WHERE I HAVE ENTERED THE DATA MANUALLY FOR SALES WHAT HAVE DONE
NOW I WANTED IS WHEN I ENTER DATE I SHOULD GET THE PRODUCT AND PRICE IN OTHER SHEET

EXAMPLE
IF I ENTER DATE IN A1 CELL
I SHOULD GET THE DETAIL OF PRODUCT IN B1-B10(IF I SOLD 10 ITEM )WHICH IS IN DATA SHEET
AND C1 - C10 PRICE (IF I SOLD 10 ITEM @THAT PRICE)

PLEASE HELP

THANKS IN ADVANCE

Your source data's layout is awkward for the purpose as it is distributed over several sets of columns
Excel works best with data in single cols (and it doesn't matter how long the col is)

Anyway, here's a tinker which could achieve your intents

In your sheet: report,
Put in E2: =OFFSET(INDIRECT("aug!B"&MATCH($A$2,aug!$A:$A,0)),ROWS($1:1)-1,COLUMNS($A:A)-1)
Copy across to F2, fill down to F12

Put in G2: =OFFSET(INDIRECT("aug!E"&MATCH($A$2,aug!$D:$D,0)),ROWS($1:1)-1,COLUMNS($A:A)-1)
Copy across to H2, fill down to H12

Repeat the construct for the other 3 sets of source columns to match into adjacent cols to the right,
ie just change the OFFSET's anchor part, viz: INDIRECT("aug!E"&MATCH($A$2,aug!$D:$D,0))
to these:
INDIRECT("aug!H"&MATCH($A$2,aug!$G:$G,0))
INDIRECT("aug!K"&MATCH($A$2,aug!$J:$J,0))
INDIRECT("aug!N"&MATCH($A$2,aug!$M:$M,0))

The above when done, automates the required base checks and populates cols E to N
- There should be only 1 set of non N/A results within cols E to N for the date in A2

Then to gather that set of non N/A results from cols E to N ...
Put in B2: =INDEX(E2:N2,MATCH(TRUE,INDEX(E2:N2<>"N/A",),0))
Put in C2: =INDEX(E2:N2,MATCH(TRUE,INDEX(E2:N2<>"N/A",),0)+1)
Copy B2:C2 down to C12
----------------------------
Success? Celebrate it, click the little star at the bottom left of my responses