Call Cell in a named range

[caippers]

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.

[Sadath31]

try using INDIRECT function

eg =INDIRECT("Master Requirements Data"!&A1)

[caippers]

try using INDIRECT function

eg =INDIRECT("Master Requirements Data"!&A1)

I tried this and received the formula contains an error.