forcing caps lock

I have to setup a spreadsheet but i want to have all the data in the same format.

Once they complete the data entry sheet the data is displayed on another spreadsheet. I would like to make everything on this sheet in capitals letters.

whether it is typed in caps or not.

Can it be done in either the entry sheet that it makes it caps or in the formula transfering the data

thanks

ps - some cells are text and numbers if that makes a difference.

Worked This Out

=upper()