You need to enter =INDIRECT(C1) as a custom data validation on your cell. This probably isn't the place for a full explanation of the data validation options and dialogue, but I thing if you Google with Excel Data Validation you'll find a tutorial.