Create button to Export cell Data to new table.

I would like to create a "Export Data" button to export information from my "Calculations" sheet to my "Summary" sheet, and fill out the table.

Calculations - Sheet One
Green fields support data entry
Orange fields are formula cells
White fields are simply units of measurement
Reset Calc button simply resets Green Fields

I would like to export the data from the green and orange fields in the "Calculations" sheet into the "Summary" sheet and fill out the certain fields as highlighted. I have filled out the cells with the cell number that it needs to be populated from the "Calculations" sheet. I also would like it to add the unit of measurement to the result, if we can add that to the code?

I also have numerous calculations to add to the table, so I have to export/reset/export the results into the Summary Table to then be able to print out a spreadsheet of results. So I need to be able to export to the table and then have it export new calculations below the previous calculated results. I dont know if there can be a code to simply 'insert data at next blank cell'? I have added a "Antenna Number" data entry cell in my calculation sheet, in the hope that it may help this problem -
eg: Enter data "Antenna Number 1" > Export Data > Data is filled in rows 3 and 4 for Antenna 1
"Antenna Number 2" > Export Data > Data is filled in rows 5 and 6 for Antenna 2 and so on
*another idea might be to export data to the summary sheet, and then insert 2 new rows, so it essentially exports into the "same" 2 rows, but the data just gets bumped down.

Finally I will then add a "Reset All" button to clear calculations and summary sheets with a confirmation before doing so, but this should be easy enough.

Thank You

Calc Sheet.png
Summary Sheet.png

I can't promise a working solution but it would be easier to help if you could attach a copy of the file instead of pictures. This would make it easier to test a possible solution.

What is the password to unprotect the "Calculations" sheet.

Assign the macro in Module2 of the attached file to the "Export Data" button.

Hahahaha that is amazing, thank you so much Mumps, I'll have to review your code to see how you did that. Amazing! Thanks again.

Also figured out I can add the units of measurement in Cell Formating Options. Custom - Eg 0.00 "m". Makes things a little easier code wise.

You are very welcome.