Hello All, I want to create an automation around: 1) Merging 2 sheets from 2 workbooks 2) Add predefined formulas (vlookups) 3) Create pivots I will email the dummy files and provide further details once someone wishes to have a look. Thanks!