Lookup from fixed rows and dynamic columns

Hi,

I have 2 workbooks, one which contains an extract of data from a telephony system and one which I'm using to calculate agents stats from the other. I have the problem where the system creates over half the columns dynamically so they're never or very rarely in the same position each day. I need to be able to lookup the value for both the agent (based on their ID) and by column header so no matter where the data is output I can pull the information for the correct agent in the right column on my second sheet.

I've attached a sample of information which is part of the report that I get from the telephony system so you can see the type of data I'm looking up. The problem is I'm not sure what order they'll come out each day so is it possible to do what I'm after? The calculation report is going to be looking up the value for the agent and then working out percentages for time spent in each state by team which is why I need the two spreadsheets.

I'm sure I did this in my last job but didn't take the work with me to my new job so have completely forgot what I did. I think I used the SUMPRODUCT function in a formula but the column headers may have been static in those tables. Hope this can be done and thanks in advance.

EDIT: Just thought the title is wrong as the rows won't be fixed as I'll be putting the agents into tables based on their teams so both row and column is dynamic if it makes a difference.