Lookup from fixed rows and dynamic columns

It looks like it could work but doesn't give me the right information in the right columns as I want the data for AGENTTIME in the corresponding column and so on. Does MATCH work on column numbers or does it match the string in that cell? I need it to match the text due to the columns changing place in the sample worksheet.

I should've also explained the sample worksheet better, the seperate numbered tabs are the days e.g. 1st, 2nd, 3rd etc of the month and the second worksheet will be the one that will have the formulas looking up the data in similar numbered tabs. I've attached both of the workbooks this time so you can see the result I'm looking for.

I tried following the formula that you put in the attached file and it had the wrong data in the wrong columns which is the same as what's happened in the example you attached.

Thanks

EDIT: Ignore this after some tweaking I managed to get it working I just had to edit the cells it was starting at in order for it to select the right one. So this is now solved. Thanks