Lookup in multiple tables

Hi all,

I have an excel file which will help us to manage our tasks on weekly basis. The layout I will describe as followed: It basically has two sheets. One sheet is a sheet with multiple tables, each table represents a project, each project having multiple tasks. For the other sheet it will function as an overview of all the tasks together. This sheet we want because we want to be able to sort on priority of each tasks. Now I have two problems basically. The first problem is: I don't know how to search in multiple tables at the same time. I know how to search in one table and returning multiple values which I have done (check the excel file). I think it can be done with the CHOOSE function but I don't know how to input it inside my current formula:

=IF(ROWS($C$12:C16)<=$D$5,INDEX(working_task[Task Description],SMALL(IF(working_task[Owner]=$D$4,ROW(working_task[Owner])-ROW('Week 28'!$E$12)+1),ROWS($C$12:C16))),"")

The second problem I am facing is:
The goal of the second sheet is to sort all the tasks by priority. In that way we can put all the emergency tasks on top regardless of which project. However, it seems to take over the filter from the first sheet. What happens is, if in the first sheet the table is sorted by due date this also happens for the second sheet. When on the second sheet sorting on a different way it does not have effect because the sorting from the source seems to "overrule" this.

If we cannot sort separately in the sheet with all the tasks doing all of this is not necessary.

I have tried it to explain it clearly as possible. I think looking at the excel file also will help to create the idea. Another thing, as I am new here.. This are basically two questions, is the way of working to ask them separately as well?


I hope one of you can help me

Thanks a lot in advance