Consolidate a list of tasks from multiple tabs into one tab

Hello,

 

I have three tabs that each list a number of tasks that need to be completed. I would like to create a summary tab that lists all of the combined tasks (backlog) in one sheet. These tasks are text. I cannot use macros since the sharepoint file will not support this function. Can anyone suggest a way to populate these tasks into one sheet? I would also like it to auto populate as I update the tasks.

 

For example,

Finance Tab

Task A 

Task B

Task C

 

Accounting Tab

Task D

Task E

Task F

 

Desired Result:

Summary Tab

Task A (finance)

Task B (finance)

Task C (finance)

Task D (accounting)

Task E (accounting)

Task F (accounting)