Google script to copy selected cells if checkbox is checked

[Andreas Widlöf]

Hi, 

I am painfully new to Google scripts, but from what I can read Google script is the only way to perform the task I want in Google Sheets. 

I am building a delivery planning sheet for our warehouse staff to use to plan deliveries on a weekly basis. I would like to find solution that allows for selected cells to be copied to the sheet "Restlista GBG" if the checkbox "Restnotering" is checked in any of the 52 sheets that make up the weeks for 2021. The copied cells can come from any of the 52 weekly sheets and the next copied cells need to follow below the last current row. The checkbox is in the same column for each week.

We have multiple users working in the spreadsheet at the same time and on different sheets. 

I would like to select which cells to copy to "Restlista GBG" and also add a checklist on the sheet "Restlista GBG" which hide the row once it is handled. 

I have spent hours on YouTube and different forums to try and figure out how to do this, but I am lost. I feel my last hope to try and find a solution for this is to turn to the pros. 

If anyone can point me in the right direction I would be so thankful!

I am attaching a link to the spreadsheet I am working on. 

https://docs.google.com/spreadsheets/d/12W-As4BpSv5HAsYguC0esPTfQ9Hdg8tgpfQBgR3OdV0/edit?usp=sharing

Thank you!

Best regards, 

Andreas Widlöf