arrange complex excel data from different worksheet and sort into one database

Do you just need to return columns M, N, and O, based upon the FC and position criteria? If so, I can get you a working formula pretty quick.

And....is each position truly unique? Or would one position be repeated in the various categories? That could make things more fun.

How "static" is Column A? Do you frequently update the positions and titles and such?