Excel Form to History Automation

I'm looking for an experienced Excel developer to automate data entry from a form sheet ("Formulaire") to a history sheet ("Bon_Historique"). When I click a "Valider Bon" button, I need all entered data to be automatically copied into "Bon_Historique," with each Bon saved in a new column rather than a new row. It's crucial that even if the data in the form is deleted, the saved Bons remain intact in the history.

Key Requirements:
- Develop a macro or script to automate data transfer from "Formulaire" to "Bon_Historique."
- Ensure each Bon is saved in a new column.
- Maintain historical data integrity even after form data is cleared.
- Handle mixed data types (text and numerical) with more than 10 fields per Bon.

Ideal Skills and Experience:
- Proficiency in Microsoft Excel, including VBA for automation.
- Experience with data management and automation in Excel.
- Strong understanding of handling mixed data types and ensuring data integrity.
- Ability to create user-friendly interfaces and buttons for seamless operation.

If you have the expertise to streamline this process and ensure data accuracy, I'd love to hear from you!