I am referencing another cell on a worksheet that has imported data from the web but when i refresh the data connection, i lose the cell reference in the formula and it goes to #REF!

Example:


=IF(ISNUMBER(DailyStatsData!A216),DailyStatsData!B216,"")

changes to

=IF(ISNUMBER(DailyStatsData!#REF!),DailyStatsData!#REF!,"")

The DailyStatsData sheet is imported data from the web that is always in the same format.

Can someone help me out? How should i be inputing the formula so that when i refresh the data i don't get a #REF! error