Hi, i have an excel document that contains 5 worksheets as follows:
1 - ALL TASKS
2 - HR
3 - IT
4 - MARKETING
5 - COMMERCIAL
As you can see above, i have a different worksheet for each division within our company and an ALL TASKS sheet.
Each division worksheet contains a simple list of tasks for that division. I now want to be able to pull and display all of the tasks from each division worksheet into the ALL TASKS sheet as an overall view of all tasks... can anyone help me with this, thanks in advance