Loop through range and get column header for each cell containing a value

I need to loop through each column starting at E2 to the last used column and get the column header of each cell that contains a value. Attached is the spreadsheet I am working with just in case my explanation isn't clear.

I do a lot of my work in Access VBA so I'm a newb when it comes to Excel. I am totally stumped on how to do this, so any suggestions is greatly appreciated!

Thanks for the quick reply protonLeah! I apologize for the delayed reply.

The document names obtained for each job title can go on the following sheet. One column will hold the job title, and the following column should hold all of the document names obtained that is related to the job title. What event is this sub procedure called? I see that Excel's vba event procedures are almost completely different than Access events.

Sorry for the late reply, protonLeah. Thank you for the explanation of the code and how it works. I was making it a lot harder than it actually is. I barely do any development in Excel so the ranges and functions are totally new to me. Do you know of any good Excel books or online tutorials (preferably free) that I can take to get a better understanding of development in Excel?