Revenue report depend on date

[forza fiume]

Dear Mr Excel,
of course, I have a problem.
In the hotel where I work, we have to make a daily report of sold souvenirs and other items. I solved columns K,L and M but I have a problem with column N.
For now in cell N3 formula is =XLOOKUP(K3;$A$3:$A$301;$D$3:$D$301;0; 0) and that is fine for one day.
My wish is that column N show value depending on the date chosen in N1( drop-down list). Which formula can choose D, E, F ...etc. for every day in a month

Daily report should be saved like a PDF to send to the bookkeeper.
Excel file must have a sheet for every month.

thank in advance
PS.
Sorry on my broken english

 

[forza fiume]

Obviously, I do something wrong.
Solution , sort with DATA-Filter, copy Paste