Hi Jignesh,

Yes, there is a way to copy the sheets and formulas without copying links. You can use the Paste Special feature in Excel to achieve this.

Here are the steps to do it:

1. Copy the sheets from the source workbook to the destination workbook using the code you provided.
2. In the destination workbook, select the cells that contain the formulas with links.
3. Right-click on the selected cells and choose "Copy" or use the keyboard shortcut "Ctrl+C".
4. Right-click on the same selection of cells and choose "Paste Special" or use the keyboard shortcut "Ctrl+Alt+V".
5. In the "Paste Special" dialog box, select "Values" and click "OK".

This will replace the formulas with their values, removing the links to the source workbook.