If you were copying Sheet1, Sheet5 and Data1 separately with separate copy
command in your code, you would do it all at once, then process each sheet
with your code except that you shouldn't need to change any links if the
links are all references within these three sheets (as an example).

--
Regards,
Tom Ogilvy


"ll" wrote in message
oups.com...
Thanks Tom,
How would the code you provided be implemented? Is there a bit more
code that goes with that?

Also, as there are 'local' (to the local workbook) formulas that I
want to keep, I do need to copy the formulas, rather than the values.

Thanks again,
Louis