Wow, I can see that you have put some considerable time and energy into this - many many thanks..! What you have produced for E32:H38 is spot on but C32:D38 is not looking at the source column which is col C of the traffic sources tab..

C32:D38 should read..

lnkd.in 51
intranet.vesuk.local 27
linkedin.com 18
t.co 13
flipboard.com 4

if tried to amend your formula in C61 

=IFERROR(INDEX('Traffic Sources'!$D$2:$D$800,SMALL(IF('Traffic Sources'!$D$2:$D$800=$AC$32,ROW('Traffic Sources'!$D$2:$D$800)-MIN(ROW('Traffic Sources'!$D$2:$D$800))+1),ROWS($1:1))),"")
to pick up the Source Col C of the traffic sources tab but without luck!

Hey NDM, I appreciate your effort and realise that any further work on this may be a ball ache, so no worries if you cant pick this up again!

All the best Sir