How to save data on next row

Hello everyone! I'm super new to macros and scripts so please bear with me.

Scenario:
a. I have some data on a spreadsheet where the function that I'd like to happen are the ff:
- A save button (image), when clicked, saves the data from specific cells to a new sheet
b. All the next data that will be saved should NOT overwrite the previous row's data (right now, the save button works but when I save it again with a different entry on the cell, the new value overwrites the previous value)
c. The next saved data should move down to the next available row

Right now, this is the only macro script I was able to create (this is literally my first day on Macros!):

function Test1() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('M2').activate();
spreadsheet.getRange('B6').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
spreadsheet.getRange('N2').activate();
spreadsheet.getRange('B7').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
spreadsheet.getRange('O2').activate();
spreadsheet.getRange('B8').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
spreadsheet.getRange('P2').activate();
spreadsheet.getRange('G7').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
}


Any help will be greatly appreciated!

Hi Norle!

I did a new code which now copies to a new tab within the sheet:

function James1() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('B6').activate();
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Dump'), true);
spreadsheet.getRange('A2').activate();
spreadsheet.getRange('Form!B6').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Form'), true);
spreadsheet.getRange('B7').activate();
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Dump'), true);
spreadsheet.getRange('B2').activate();
spreadsheet.getRange('Form!B7').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Form'), true);
spreadsheet.getRange('B8').activate();
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Reference list'), true);
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Dump'), true);
spreadsheet.getRange('C2').activate();
spreadsheet.getRange('Form!B8').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Form'), true);
spreadsheet.getRange('F7').activate();
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Dump'), true);
spreadsheet.getRange('D2').activate();
spreadsheet.getRange('Form!F7').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
};

What I really can't figure out is what do I need to add so that new entries do not overwrite previous ones and just place the new values on the next available blank row.

Sure! And yes, I'm only trying to copy and paste values

A. Copy values from specific cells of "Form" sheet to "Dump" sheet

Here's the spreadsheet file I'm trying to work on: 1gdVFQ_JXW3SpPnw1Trx-J-9putO00jJ2vPc09KrdgzY

Really sorry if I'm confused!

OMG!!! You are a life saver!!! It works!!! I'll try to search how the script works but its brilliant!!!

Just a few follow up questions though:

1. How do I add additional values to get from the Form tab?
2. Do you have any recommendation on how to create a "Clear" button, which resets the form once it's saved and the put default values in once cleared?

Thank you so much Norle!!!

Got it! The cells work now! You are the best! Thank you Norle!