Grouping info on reports


Hi all,

I have 3 spreadsheets for which i want to report information from.

All of them have common information/references (i.e. POW1234) but the name of the columns where that information is will be different from spreadsheet to spreadsheet.

Is there a way to, on reports compile or group all the rows that have the same reference in 2 different columns?

Thanks in advance.