Way to see all tasks assigned to you/others over multiple sheets?

Hi, i am looking to make it so that I or others in the office are able to see all of the tasks assigned/items relevant to them in one place as opposed to having to click on every single sheet. My best understanding is that this is done through reports. However, lets say in one sheet the column is "assigned to" and in another sheet its just called "assigned" it will only show either assigned or assigned to depending on what one i select. I work in a large corporation so uniformity when making column headings is not easy. I am wondering if anyone is able to provide me with any information or tricks to get past this