Add a copy tab function, but remove all the formulas

As variant with Office Scripts

function main(workbook: ExcelScript.Workbook) {

    const fromSheet = "Source sheet"
    const toSheet   = "Target sheet"

    const source = workbook.getWorksheet(fromSheet).getUsedRange()
    const address = source.getAddress()

    workbook.getWorksheet(toSheet)
        .getRange(address.slice(address.indexOf("!") + 1))
        .copyFrom(source, ExcelScript.RangeCopyType.values)
}