consolidate data from multiple tabs in the same excel file

Hi All,

Apologies beforehand if this question sounds stupid.

I am trying to do a consolidation of all the data from a few tabs. I also need to be able to update anything in any of the tabs and the results should be shown in the consolidated tab.

I am only able to do the consolidation whereby i can update the numbers of hours and it will be dynamically reflected in the consolidated page. But this is not what i want. I want to be able to add a new line e,g 'project abc - 100 hours' and this line would be reflected in the consolidated page dynamically.

What i am trying to update is this,
project name - 10 hours
project xxx - 10 hours.

Cheers,
Alex