If your data is in Sheet1 and your data validations in Sheet2, then the formula would be more like:

=INDIRECT("'Sheet1'!"&B1)