Thanks guys. It works great. Btw, how would I add color to & Sheet1!A1 once it inserts the word from this cell??
Originally posted by WillR
In Sheet 2 A1 place the following
="This animal is a " & Sheet1!A1 & " and..."
Hope this helps,