How about type = in the master sheet
navigate to the source sheet and click on that cell
Enter

if you need to add the different values in these source cells,
simply type + and repeat 2nd step of the above

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"TechGuy" wrote:

I have a multitude of excel files which I need to pull data from into one
master sheet. The problem is the data in those cells may change from an
individual sheet. Is there anyway to change the cell of the individual sheet
and see those changes on the master sheet I am creating? Thanks.