Automatic Update in Multiple Worksheets
 

I am trying to setup worksheets that stem off of one master worksheet to
automatically update data on all worksheets when entered into the master
worksheet. I don't want to just input =sheet1!A1 because then it returns null
values which mess with another sheet and my charts. Basically I want a way to
update without #NA everywhere and drag and drop through multiple sheets
Thanks