Create a data entry form for Excel

Hello,

I would like to create a data entry form in Excel so that by clicking button named "Create BKA", it would a open a data entry pop-up window as shown in the attached Excel file. After entering this required data in pop window, it should be copied in the next available free row such that each entry should appear under the respective column title as mentioned in the data entry form.

I would really appreciate the help of expert in this forum to solve this problem as I am still learning the macros.

Thank you in advance!