Excel 2010 View cell from a different tab

[Melanie]

I have a spreadsheet where a cell (let's call it 'A') on a different tab is linked to a cell (B) on the current tab. I want to be able to visually see the impact on cell (A) by changing cell (B) within cell (B)'s tab.

Is there a way to insert a camera type view of cell (A) on the current tab?

 

[MikeDBMan]

Either I am missing something or all you'd have to do is create a linked cell (C) on the tab that B is on. That cell's formula is a link so that it equals A. Then when you change B on this tab, you'll see C, which is the same as A.