hi,
you can use a formula.
if you had data in sheet 1 cell A1 and you want this shown in sheet 2 cell
d5, then in D5 put the formula =sheet1!A1.
what ever is in sheet 1 cell A1 will also show in Sheet 2 cell D5.
NO macro needed.

Regards
FSt1

"Kiba" wrote:

Ok So I have a worksheet, currently it has a macro that copy and pastes data
from the master sheet to several other worksheets. Some of the sheets are
hidden and inorder to copy and paste to them when the update button is
pressed I have to un hide and re hide. Is there a way that I can link cells
so that they can update when button is pressed without unhiding?