Show a random cell from a chosen column to a different worksheet.

Basically, what I am trying to achieve is to have a cell on one sheet that will retrieve a random cell's data from another sheet.

So I'll have column A in the sheet named "data", which will contain a list of games that I want to play. What I want is for one of the games(read cells) in column A to be randomly selected and shown in the sheet named "now playing".

I'm aware of the ='data'!A1 but this only shows me the specific cell. What I want is for excel to show me a random cell from a given range, say A2-A13.

What I am trying to achieve to have a spreadsheet that will show me what games to play next by randomly choosing a game from a list on another sheet.

I truly appreciate any response and will respond asap.

Originally Posted by Special-K

Try
=INDIRECT("'data!A'&(RAND()*12+2))

Unfortunately that didn't work. I'm a bit of an excel newbie, so should I be putting anything in that formula? thanks for the reply.