Find text in multiple cells and return different text

MLloyd81, Good morning.

Dear teacher, maybe I'm missing something in your explanation.

Wouldn't the MATCH function be useful to you in this case?

A little image of the spreadsheet would already help me understand your layout and what you want as a result.

Hope it helps.

Thank you for your reply. I am a novice on Excel and only know a few formula and Google helps with the rest. 
I have used the EXACT formula but it only works for one cell. 
I have a number of sheets, all with a similar format and I wanted a snapshot sheet so I could see the level of each child in each area at a glance. Any help would be appreciated. 
thank you 

Welcome Teacher.

Don't worry,

All of us, at one time or another, were also beginners in some subject.

Could you please, show us a view of your spreadsheet and what a desired answer would look like for you?

So the top sheet is the analysis sheet with all of the names of each section at the top with the list of children down the rows at the side. The bottom picture is an example of each sheet and the assessment, it consists of a range of statements in each level moving from Bronze up to Outcome 6 and there is a column for each child in the class across the top. Each sheet is a similar format.  You can select from the drop down in each box to say whether the child is emerging, developing or secure in this skill level. This assessment is done at the start of the year. What I want to happen is that in the analysis sheet, the child will show the level (Bronze to Outcome 6) in the cell for each column related to the skill. So whichever cell says secure in the individual sheets the corresponding level will appear in the analysis sheet under that section and this will be different for each child. 

Technically I want to search the cells for the child and find the box that says secure, then the corresponding level will appear in the analysis sheet. So if D4 is secure Gold will show. I hope that makes sense.