Always pull in the value from the same cell
I'm trying to pull in a text value form a 2nd sheet. The value I'm trying to pull will always be in cell [TextToPullIn]1 for example. That second sheet is populated by a form with the latest entry always on top, and the text I want to pull in my first sheet will therefore always be in the same cell. Any ideas? Maybe I'm thinking too hard... Thanks.