How to create a button to transfer data to another tab within the same spreadsheet?

We have been using a spreadsheet in Google Sheets that allowed us to transfer data from one tab to another tab within the same sheet. We are wanting to convert everything from Google Sheet to Microsoft. However, when we do, not all of the formulas transfer over. Can someone please look at my attached spreadsheet and tell me what is missing to make the "Submit" button function work?

I've color coded what needs to go where. All data is transferring from the "Joey Calculator" tab to the "List of Rates" tab. The "List of Rates" tab is an on going list of data collected from the "Joey Calculator" tab. So when the "Submit" button is clicked, the data needs to be added at the bottom of the list in the "List of Rates" tab.

.
This macro will replace the current function you have listed in the workbook. You no longer need the original function.

Please Login or Register  to view this content.

That fixed it. Thank you so much!

.
You are welcome. Please mark this thread as SOLVED.