Tasks list report - from different sheets with different column names
I have a problem with my task report , when I want to filter it for one specific person. I have 3 columns, from 3 different sheets and they all have their own column name for "Assigned to", such as 1, Assigned to, 2, Responsible person and 3, Responsible.
And I do not if it is possible to filter from these 3 dif. columns one name so I can create task list for one person.
Do these columns need to be named the same or is it possible to somehow filter it?
Any help or advice is welcomed :)