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.

I would recommend changing it to be a little more specific if you need help with a particular problem..."Formula Help" on an Excel Forum is a little vague, and also if you are posting on an Excel forum, everyone already knows you probably need help with a formula

If you could upload a sample workbook as well, with any sensitive information removed, it would be a lot easier to assist you with this issue!