I wrote a macro that replaces a particular tab within my workbook with data stored online. I have formulas within this same workbook that call that particular tab

ex ='Master Requirements Data'!A2

well everytime the tab Master Requirments Data is refreshed with the new data I receive an error #REF

So I changed my macro to change the data in the Master Requirements Data tab to create a named range.

How can I have my forumla call a particular cell within the named range

=master!A1 or something like that.

Any help would be appreciated.