VBA to add selected worksheets to basic workbook

[NorthNone]

How can I use VBA to add standardized worksheets from a template to an existing workbook?
I have a 3-worksheet workbook to which users may want to add standard-form supplemental worksheets. Once these standardized worksheets are imported from another template, formulas for a few cells in Sheet1 of the original workbook have to be changed to reference the new supplemental worksheet instead Sheet2 of the original workbook.
Users could add eight to ten worksheets this way. I've done a lot of VBA Access coding but not much Excel.
TIA
North
P.S. I'm not opposed to creating the supplemental worksheets strictly in VBA code from within the 3-worksheet workbook, but am not sure my Excel VBA skills are up to it.


"Talent hits a target no one else can hit; Genius hits a target no one else can see." --- Arthur Schopenhauer

 

[SkipVought]

Check out the native Excel Edit > Replace feature in order to replace the PATH to the source workbook in formulas.

Use your macro recorder once you figure out exactly what will work.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}