Copying Over Date In Separate Sheet With New Rows

I'm trying to create an excel that is composed of multiple sheets that the user updates frequently.
On one sheet the data is stored with the date on top with the user filling it out from top to bottom daily.
On the second sheet I need certain cells to be pulled and the date, but need this to be appear horizontally. I want this to up updated automatically, so as soon as the user inputs something into sheet 1, sheet 2 updates. Preferably using formulas, and not VBA.

This is where I'm stuck- with how to include the date and create a new row of data.

I've included pictures, the first is an example of how the user would fill in the data. Sometimes the user would leave the some of the rows blank ( row 22-25), in that case those blank rows shouldn't be carried over to the second sheet. The second image is the sheet that shows how I want the information to be viewed ( with the date carried over and a new row created for each).

Sorry about that new to posting on here!

The file you attached is exactly what I want to see!

But wondering how would i do that if i keep adding date values, like sept 23,24, 25 etc as the excel sheet would be updated daily. i attempted to expand the columns referenced =LET(A,A3:A22,B,B3:F22,C,B2:F2.... which works if i have data in the rows under those columns. But how would I make it constantly update as the user puts new data in? If I expand the columns referenced like above when there is no data in their associated rows I get a CALC error. The user is going to manually update the date daily.

Lastly is there a way to have the expected results appear on a second sheet automatically as the user updates the first sheet? As different users will be using each sheet.

Thank you!

So my data has multiple rows and starts a few lines down from the sheet so I changed it to...
=LET(A,A30:A130,B,TOROW(B2:H2,1),C,CHOOSECOLS(B30:H130,SEQUENCE(COLUMNS(B))),D,UNIQUE(A),.....

I attempted to change where it starts ( from A3 to A30) and expand the number of cells it includes from A but i get a CALC error. Not sure what I would have to change? Not all the cells in B30:H130 would have data, but there is the potential.

Yes let me upload a sample book that shows how the data is structured ( put some dummy values/names of headers).

So its all of Row 1 ( A1:ZZZ1 the date), and then everything from row A33-ZZZ144 that needs to be included in the new sheet ( i chose ZZZ just since the columns could be infinite). some of the cells include drop down, and then some are numbers and some text while some can be left blank.
sometimes there will be blanks within thesection(example cell A40 in section B33:B40).
the blanks shouldn't be included in the output for the new sheet. the user will always fill from top to bottom, so from cell 33 onward. they wouldn't skip to cell 57 and start from there.

Im hoping this makes sense, thanks for being patient with me!

Thanks Glenn! This worked out for me and i changed the columns so no longer ZZZ.
Much appreciated!