VBA Paste Transpose Into New Worksheet First Open Row

Hi Everyone,

I am working on a project where I need to copy a range of cells (C3:C30) in a column and then paste "values only" and transpose into the first blank cell in column A on another worksheet.

I have tried recording a macro but when it runs, it always pastes into a static cell. (the one i clicked on when recording which was blank)

I am trying to then clear the original range of the selected drop downs text (but not the data validation for each cell) with the intent of clicking a button to paste the data into the next worksheet indefinitely and resetting the original form for use.

Thoughts? Suggestions?

I have uploaded a mock-up of the workbook I am referring to.

Thanks for your help!
Les