combine multiple sheets easily . go to Add-ons > Combine Sheets > Start to start. it will automatically look for the sheets in your workbook. then select the sheets you want to combine and hit combine button. using this addon you can either appends entire data to the existing data or replace existing data with the new data. you can also choose if headers are there in the sheet .