Open both...
Copy 'si', switch to 'ys' in Master
Edit | Paste Special | Links | Paste Link

Save and close Master...
Whenever you open Master next, choose to update links...

"Nev" wrote:

Hi there

I really hope you can help. A macro wont work so hopefully you can!

I want to automate copying values only of Worksheet "si" in the current open
work book to worksheet "ys" in workbook Master Copy which may or may not be
open.

Look forward to hearing back

Thanks

Nev