Defined Names Not Working on Specific Sheet

Hey guys, one of the defined names in my workbook will return a #REF! error on one tab of my workbook, however on every single other tab it pulls the correct cell value.

Any ideas why this one tab would be rejecting it?

Thanks

When your defined name is selected in the Name Box, does it refer to the correct cells?

I think I figured it out. Thanks. In the name box there were two names, one that referred to the correct cell and one that tried to refer to a cell within the tab.

Thanks everyone.