|Not sure I understand what your trying to do.|
Do you simply want the Text string "Tabe1" or "Table2" as the cell contents?
Your heading speaks of Data Validation, is there more to this then what your showing?
Please remember, we can not see your spreadsheet, and have no idea what it is your
trying to do.