Populating Sheets automatically from a Master

[Stuck_all_the_time]

Hi everyone and thank you for reading my post.
I am trying to save tonnes of time and simplify a process of tracking learners by listing everyone in one Sheet but then have their details automatically populate a second sheet based on the value of one cell (in this case the course code), then if need be and the course code on the Master sheet changes they are automatically moved to the relevant sheet too.

I have tried Consolidating, VLOOKUP and other formulas but just can't seem to get things to work and are desperately trying to avoid VBA as I've never used it.
If anyone could offer any advice that would be awesome.

Thanks in advance..

 

[SteveO59L]

try posting a sample of your data, and what you would like to do with it

 

[Stuck_all_the_time]

Yes it would help

http://i63.tinypic.com/seq4q0.jpg