Exporting info for a report

[cruyff73]

Hi,

I've got a spreadsheet to record accuracy of my team (example below) and I need to present it in a more user-friendly format. The sheet is populated by staff filling in a userform so I can't change the format. The info I need to show would be columns A-E and the headings in F-R but only where an error is shown (ie. Row 13, I would need A-E @ F1 along with the descriptor and comment in F13 & G13). Really can't think where to start. Is it even possible?

Thanks