Copying the column header text and name of row to another worksheet if criteria not met!

A very good day to you! I apologise if this cry for help is in the wrong category, but I am new to excel and the forum and in need of an expert
to help a novice. Just looking over the site over the past few days has enlightened me already, so thanks in advance for taking the time to help me solve.

I am a teacher who has grown tired of purchasing student tracking programmes so I have taken a big leap to try and develop my own, which as certainly been an experience.

The problem I need help with is as follows -

I have my students down the far left column (30 rows) and along the top for each worksheet is the criteria which they must be able to do. If my in row 2 completes
the criteria text above in column 5 for example, then I input a 3 which then adds the points and works out their sub level scores. However I am now in need of it being
able copy the criteria above if a student on any row has a T(for target) in that box. I would then like that criteria to be copied to a master sheet which displays their
name down the side and all the targets they have for that subject in the next column, so that they can be referenced for their report summary worksheet.

How do I go about doing this? Or is it simply beyond me as a novice who just has ideas? If you could advise then keep it as simple as possible :-P And if you need anymore
information let me know.

Your help and time is appreciated.

Mr Rivers

Ofcourse, thanks for your speedy reply. I might sound really silly now, but how do I go about sending you a sample.
hehe one problem leads to a simpler one. Apologies!

SAMPLE PAGE MR RIVERS.xlsm

Thank you for your patience. Hopefully this is what you are after! This is just a sample page so you can see the layout. Any problems opening it give me a shout.

Mr Rivers

SAMPLE PAGE MR RIVERS.xls

Sorry, try this. Couldn't seem to find the save format in my options (its excel 2013 and has a million options which make no sense to me).

If this doesn't work I will try again in other formats. Sorry for being amazingly slow.

Mr Rivers

I was just checking what you think about my problem? Wasn't sure if you had replied yet as I seemed to get my sample file back with some alterations but
no notification of a message, so I was confused.

Thanks again

Mr Rivers

Oh thank you so much, I am just looking at it now and making sense of the code etc, Im not as advanced as you obviously. Cheers for taking time to do this much already.

Wow that's just what I needed. Not sure if I'm doing something wrong at the moment, but when I press the summary button on sheet 1 just A1 appears in the first column below and nothing else. Probably something I've not
done properly, but I love the idea on how it works.

Yeah, lots of 1-4s, so not sure what has happened. It just returns A1 in sheet 1 only, despite other students having a 4 - and there is no criteria text coming up on sheet 1 to say what they need to do next.
All rather complicated, I thought a challenge of doing one myself would be more rewarding and not making Easter stressful.

I've had a fiddle and can't get it to work, it works in my head though hehe. I have attached one last file to you which I have made smaller and highlighted what I would like to happen
if you or any of your expert excel friends could help further.

I thank you for taking the time to even help me - a great forum, and certainly a place which will continue to confuse me or enlighten me.

Dan Rivers

ANOTHER EXAMPLE OF WHAT IS IN MY HEAD.xls
on this example I have used a 1 to signal transfer to target page as if I use 4 then it adds lots of points to their scores and would make it higher than it should be.

Sorry just seen your message above - that's my mistake for not looking or explaining - no along the top is everything they must do before the end of the year and they can achieve them in any order - there is levels 1c/1b/1a criteria to be met (so if they are working on 1c criteria then they achieve all criteria in any order until complete and ready for level 1b - if that makes sense). My world of teaching is probably as confusing as excel is to a novice.

That sounds good to me! I have been having a novice experiment this morning, is it possible to use an IF formula to index the header row to the individual rows below and match any columns which contain the lowest score (1) so that it brings back first column to contain a 1 and pastes the header alongside the child's name (1 target at a time until achieved and it finds the next 1 on the row), I'm probably sounding silly was just exploring IF, INDEX, AND MATCH, in formula cells for sheet I want information on.

okie dokie I understand, as I only sent you a sample page just to see the layout, I will now go back to the real file and make these corrections first (I have a worksheet for each subject so I will alter them all as you said). I will then send you the sample page again if you need it without the merged cells.