Hello everyone, hope you are all doing well. I have been a long time lurker here and have learned quite a lot from these forums

Here is my question:

In the attached file, I want the button in the 'Input' sheet to populate rows in the 'Database' sheet based on the date.
Ideally, I'd want to transpose paste the values because the column headings in the Database sheet will not be exactly the same as those in the input.
For now to make it easier to understand, I've left them as A,B,C,D..etc.

Thanks in advance