Returning a value in a range if another value exists for a row.

Here is what I am trying to do.

For the Row that has Position = JobTitle1, for every column where an 'X' appears, I want the Role Name to appear as the result (ie. Role1, Role2, Role3, etc.). I need to get this raw data in a different form that can be used by our Security team. I have about 10 - 12 sheets with up to 100 rows and 100 columns of data. So I need to be able to copy the formula for each row, but still have the Role Name appear. This has stumped me. I've tried VLookup, HLookup (we couldn't really figure this out to return a result). I looked at Indexing, but that doesn't look that is what I need. I'm not sure if an "if then" or "what if" will do it either. I'm new to formulas, so your help is greatly appreciated.

I have attached a file as requested.