Append or replace data in workbooks
You can append new data to existing workbooks or replace entire sheets with revised data. If you need to do any of the following, then appending the workbook with the required data or replacing the entire workbook is a good solution: