Collect data from images to check productivity

I have our cameras set up here so that in the EXIF it records the "Owners Name" as "Shot by A. Person" and another by "Shot by B. Person"
Then after editing it adds in (of the IPTC) "Caption/Description Writer" , "Edited by A. Person" and another as "Edited by B. Person"


I'm still trying to work out how to best then display the information but I need to get a day by day analysis of productivity. So 4 columns, Person A Shot by, Person A Edited, Person B Shot by, Person B Edited then in rows of Days.

I'm using Office 2011 for mac. and the photos that it needs to look at are located on an external drive. So essentially I need to point it at this drive and then check all contents (all PSD files, exclude jpgs)?

Anyone hav any idea how to do this? I have extremely limited use of excel so I'll need a lot of help with it.

Many Thanks in advance

Matt

Obviously very basic but added a tiny amount of data to show how I think I would like it.