I need to tell you how to make an Excel table with dependent drop-down lists, who knows how?

Question

Google Sheets

The essence of the question is how to make a table with 2 two drop-down lists dependent on each other.
The idea is that there is a drop-down list No. 1 in it with a date, in the list No. 2 a name. (Red highlighted) Then there are several more columns with certain indicators that I fill out every day. How can I make it so that when I select the items I need in the drop-down list, the table is updated every day! but at the same time, the data would be uploaded somewhere on the 2nd sheet and the whole thing would be summed up in a monthly amount (for example: I chose a number, chose a name, and filled in the data for 1 number, they were uploaded to the 2nd table, on the second day I went in, did the same- it was unloaded again, and at the end it was summed up in the monthly result. I'm attaching a screenshot to make it clearer what I mean.
Or maybe there is some easier way to do this?
It is necessary to make it so that it would be possible to easily fill in certain data from Google tables from the phone (choose a model, quantity, amount)