Excel Sheet VBA Macro

Overview
I have an existing Excel workbook (PX Retail Back Calculator) that contains an input sheet where users manually enter vehicle valuation data.
I need this adapted so that:
A Submit button is added to the input sheet
When clicked, it automatically transfers all completed input fields
The data is appended as a new row in a separate Database tab within the same workbook
This is a small, clean task for someone experienced with Excel automation.
What I Need
Add a Submit button to the existing input sheet
Create (or use) a separate sheet called Database
When Submit is clicked:
All relevant input cells are captured
Data is written to the next available empty row in the Database sheet
Inputs are saved exactly as entered
After submission:
Either clear the input cells automatically (preferred)
Or optionally leave them populated (we can discuss)
Technical Requirements
Must be done using:
VBA (most likely), OR
Office Scripts (if a...