If Then Formula

I have an If Then formula I am trying to create from one tab to another

The first attachment is a screen shot of my data entry page - data is entered in columns A, B, and C. The below formula drops info into column D:

=INDEX('All Lc''s'!$O$2:$O$3609,MATCH(1,SEARCH("*"&'All Lc''s'!$A$2:$A$3353&"*",B3),0))

I need to create a formula that states if 1 one 25 possibilities pops into column D, then I want that transaction to flow into a tab named just like what would pop into Column D.

Any thoughts?