Summarise Text from data table based on lookups on row and column header

Sorry for the complicated Title. I don't really know how to explain what I need in a sentence.

I have a system where staff will input data with a user form that populates a table equivalent to DataTbl in the attached sheet.

I need to then summarise the data in a separate table where one axis shows the categories and the other shows the current weeks dates (Week commencing last friday).
The table then needs to be populated with the details (Which is free text entry) from the DataTbl, cross referencing both the row and column header.
Obviously there will potentially be more than one entry that applies and as such my intention was to concatenate the details of each entry that fits the bill.

I am happy with any solution although favourably I wont include power query as some of our systems are on 2013 and we cant use add ins.

Any help appreciated.

I would suggest you to also create a sample of excel worksheet manually enter the results you want. It would be easier for others to assist you with a solution.

Ok i have updated the sheet to show what results i want.

Hopefully it makes sense now.

The reason i don't just want to use a pivot is because i need all of the blanks and the dates have to simply show the current week (beginning Friday).
I think i might be able to force just be having VBA produce some dummy data onLoad? It's hacky though.

Is there anything more simple i am missing here?

Thanks so much for this. it works! I have no idea how but i will work it out.

Cheers mate.